Hello everybody!

Lets supposethat I have a spreadsheet with 5 columns A,B,C,D & E; lets
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