Formula needed

[aysam]

Hi all
I need a formula to return the price of an item between a column of a lot of items as soon as I write the item in a cell.
Hope I'm clear enough
thanks in advance

 

[snjpverma]

you are not clear enough. could you post small sample of your data ?

 

[aysam]

Ok
I,m using Excel 2003

ITEM <tbody> </tbody>	PRICE <tbody> </tbody>	NUM <tbody> </tbody>	QUANT <tbody> </tbody>
SAMSUNG GALAXY SAMSUNG GALAXY S3 SAMSUNG S4 SAMSUNG S5 SAMSUNG S6 SAMSUNG S7 SAMSUNG S8 SAMSUNG S9 SAMSUNG S10 SAMSUNG S11 SAMSUNG S12 SAMSUNG S13 SAMSUNG S14 SAMSUNG S15 SAMSUNG S16 SAMSUNG S17 SAMSUNG S18 SAMSUNG S19 <colgroup><col></colgroup><tbody> </tbody>	115 120 125 130 135 140 145 150 155 160 165 170 175 180 185 190 195 200 <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody>

<tbody>
</tbody>

As soon as I choose an item
the formula returns its price

 

[AliGW]

Assuming that your lookup data is in A1 to B18, and your lookup value of the phone type is in C1, this in C2:

=VLOOKUP(C1,$A$1:$B$18,2,0)

If your locale is in Europe, you'll need semi-colons instead of commas.

 

[aysam]

Assuming that your lookup data is in A1 to B18, and your lookup value of the phone type is in C1, this in C2:

=VLOOKUP(C1,$A$1:$B$18,2,0)

If your locale is in Europe, you'll need semi-colons instead of commas.

Is there another solution if the column of the phone items is not sorted?

 

[snjpverma]

Is there another solution if the column of the phone items is not sorted?

The above formula will work irrespective of the column being sorted or not.

 

[AliGW]

Is there another solution if the column of the phone items is not sorted?

As has already been stated, it works regardless because it is looking for an exact match. Did you try it?

 

[aysam]

Yes , I tried it and it worked quite well
thanks so much