Ask about VLOOKUP or HLOOUP

  • Thread starter Thread starter Putu Niki
  • Start date Start date
P

Putu Niki

I have problem :
Code Product PRICE
FLX 100
CX 200
DX 300
DCX 400

How get the price value using VLOOKUP or HLOOKUP ?
Thank you. Immidiate
 
You need to use a VLOOKUP.
A VLOOKUP is organized in the following way (Lookup Value, Table, Col Index,
Range Lookup)

Your lookup value is the value you are looking up in the table, Your table
would be something like A2:B5, your col Index is 2, and your range lookup is
probably FALSE.

So it should look something like this VLOOKUP(___,A2:B5,2,FALSE) , you just
need to fill in the underlined section.
 
Assume the reference table that you posted
is in Sheet2, in cols A to C
where Codes are in A2 down, Prices in C2 down

In Sheet1,
Assume you have the codes to be looked up, eg: DCX in A2 down
In B2: =VLOOKUP(A2,Sheet2!A:C,3,0)
will retrieve the required price, ie 400. Copy B2 down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
 
Back
Top