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 |
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 |
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 ? |
All times are GMT +1. The time now is 03:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com