Functions and Formulas

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

What I would like to do is be able to type in lets say:
Apple in A2 and have B2 automatically pop up the words
one medium,C2 automatically pop up the number 85, D2
automatically pop up the number .05, and in D2
automatically pop up the number 2.

I'm not sure if I need a separate database to pull the
information from or if I can just write a formula. I have
tried many different functions and formulas but I'm
stumped.

Please help.
 
Carla

One way is to make a list somewhere on your sheet,
for instance in H1:L100, having fruits in column H and the
matching information in the other columns.
Then in B2 enter this formula:

=VLOOKUP(A2,H1:L100,2,0)

in C2
=VLOOKUP(A2,H1:L100,3,0)

etc.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
I agree with Leo that having another chart would be the easiest. I'm
not sure how much info you have or if the info would change (for
instance, would column 2 always be medium when column 1 is apple)...IF
you don't want to have another chart & IF you don't have an extremely
long list of info & IF the info will be consistent, you could make if
statements such as:

=IF(A1"apple","one",IF(A1"orange","two",IF(A1="pear","three",...etc

You would just copy the formula to each column and change the info that
would be displayed

I understand that its not the easiest, just another option

Clay
 
Back
Top