Google Answers: Excel sheet formula

View Question

Q: Excel sheet formula ( No Answer, 1 Comment )

Question

Subject: Excel sheet formula
Category: Computers > Software
Asked by: bailey111-ga
List Price: $40.00

Posted: 27 Apr 2005 07:07 PDT
Expires: 27 Apr 2005 09:46 PDT
Question ID: 514885

Should be an easy excel question.  I would like to make an if
statement with text with multiple values.
Right now I can do an if statement like this...
(formula is =+IF(D5="Tribeca",3,IF(D5="Upper West Side",4)))

this si good, but i can only do this 4 times.  I would like to produce
a much more exensive code list.  For instance, a single corresponding
code with text, but an extensive list...
anyway someone could help me with this, is it possible?

Tapas	20
Italian	15
Chinese	11
American	7
Chinese	11
Chinese	11
Sandwich	
Italian	15
new	
American 	7
Japanese	16
American	7
American	7
Chinese	11
BBQ	9
Italian 	15
italian	15

Answer

There is no answer at this time.

Comments

Subject: Re: Excel sheet formula
From: shockandawe-ga on 27 Apr 2005 07:33 PDT

Excel has several "Lookup" functions just for this kind of purpose.


http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy