(Msg. 1) Posted: Mon Nov 17, 2008 7:02 pm
Post subject: Ask about VLOOKUP or HLOOUP Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
(Msg. 2) Posted: Mon Nov 17, 2008 7:51 pm
Post subject: RE: Ask about VLOOKUP or HLOOUP [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
(Msg. 3) Posted: Mon Nov 17, 2008 7:55 pm
Post subject: Re: Ask about VLOOKUP or HLOOUP [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office