The fruit problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Roger,

It is VLOOKUP

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

The false is used in case to ensure an exact match.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Categorizing Data Question 4
Referencing text from another cell for criteria in functions 1
Nested formula...I think 1
dependent drop down list 1
How to total words 2
What would be the most effective way to do this? 5
Sum of different value in different worksheet & cell number 2
Array reference 1

Back
Top