new to IF's (or vLookup)

[JohnB]

What would be the best way to accomplish this;

I want to test the value of the first cell, it can be 1 of 3 different text
strings, with the second field filled with an integer value, based on the
test results. I'm guessing I need multiple IFs? What I'm stuck on is, how
do you string them together?
Thanks



| text string1 | integer |
| text string2 | integer |
| text string3 | integer |

 

[Anne Troy]

Try this:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

Do you mean

=IF(AND(OR(cell1="text1",cell1="text2",cell1="text3"),cell2=integer1),action
_true,action_false)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[JohnB]

I want to test c14 for one of the 3 string values. And then fill E13 with
one of the 3 integers, based on the test.

Am I even close?

=IF(AND(OR(C13="Spruce Creek",C13="Stone Creek",C1="Fore
Ranch"),E13=34,E13=10,E13=6),action_true,action_false)

 

[Bob Phillips]

Then add this to E13

=IF(C13="Spruce Creek",34,IF(C13="Stone Creek",10,IF(C1="Fore Ranch",6,"")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[JohnB]

Ahhh... I can see clearly now!!

Thanks Bob!

Then add this to E13

=IF(C13="Spruce Creek",34,IF(C13="Stone Creek",10,IF(C1="Fore
Ranch",6,"")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)