Ask about VLOOKUP or HLOOUP
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.
"Putu Niki" wrote:
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
|