The fruit problem

R

Roger

Hello everybody!

Let’s supposethat I have a spreadsheet with 5 columns A,B,C,D & E; let’s
say that column A is made of a list of fruit, such as apple, bananas, etc and
column E is made of prices.
My questions is: provided I give the name of the fruit that I am looking
for, can excel give me the equivalent price on column E ?

Not sure if the formula would be similar to a Vlookup, kind of "look at the
fruit "X", in column 'A', and give the equivalent price on column 'E'

Any help will be the most appreciated.

Anyone?
Regards,
Roger
 
B

Bob Phillips

Hi Roger,

It is VLOOKUP

=VLOOKUP("Apple",A1:E100,5,False)

The false is used in case to ensure an exact match.
 
Top