Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ask about VLOOKUP or HLOOUP
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ask about VLOOKUP or HLOOUP
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 --- "Putu Niki" wrote: Code Product PRICE FLX 100 CX 200 DX 300 DCX 400 How get the price value using VLOOKUP or HLOOKUP ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |