Home | Software > calc > VLOOKUP | About

Look at the following table and display in cell D14 the price of the item whose part number is in D13.

Img is from here

The right formula to place in D14 is : VLOOKUP(value,range,index)

where :

  • value is what you're searching
  • range is where you're searching
  • 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)

contact : @ychaouche yacinechaouche at yahoocom

QR Code
QR Code vlookup (generated for current page)