Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
vlookup [2016/12/07 16:42]
yassine chaouche
vlookup [2016/12/07 16:43] (current)
yassine chaouche
Line 12: Line 12:
 where :  where : 
  
-''​value''​ is what you're searching +  * ''​value''​ is what you're searching 
-''​range''​ is where you're searching +  ​* ​''​range''​ is where you're searching 
-''​index''​ 2 means return the value of the second column in ''​range''​+  ​* ​''​index''​ 2 means return the value of the second column in ''​range''​
  
 If you understood all this, you should come up with ''​VLOOKUP(D13,​B2:​E11,​3)''​ If you understood all this, you should come up with ''​VLOOKUP(D13,​B2:​E11,​3)''​

QR Code
QR Code vlookup (generated for current page)