Google Answers Logo
View Question
 
Q: Excel Formula Question ( No Answer,   3 Comments )
Question  
Subject: Excel Formula Question
Category: Computers > Programming
Asked by: flamingodee-ga
List Price: $5.00
Posted: 04 Jul 2006 13:41 PDT
Expires: 03 Aug 2006 13:41 PDT
Question ID: 743330
A   B    C
1  1   1    A
2  1   2    B
3  2   1    D
4  2   2    C
5  1   3    A 
6  1   4    A
7  1   2    ?

If I plug a value in A7 (say 1) and B7 (say 2) then I should get the
letter in C7 based on the table - can you do it with an If Then
Statement and possibly another way as well?  I did figure out a
Vlookup already.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel Formula Question
From: jack_of_few_trades-ga on 05 Jul 2006 04:57 PDT
 
Are the numbers representative of code?  I'm a bit confused as to how
the letter is determined.
Subject: Re: Excel Formula Question
From: respree-ga on 05 Jul 2006 18:09 PDT
 
What is the relationship between columns A, B & C?  I don't see any
connection (with any basic operators : +,-,x,/).
Subject: Re: Excel Formula Question
From: slipperycat-ga on 02 Aug 2006 16:38 PDT
 
You can use the IF and AND in combination to get the result you want. 
IF can be strung together 7 times.  IF takes 3 parameters the first is
the logical test in this case well use AND.  The second parameter is
the result IF the logical test is true and the third parameter is the
result if the logical test is false.  By using an IF as the third
parameter I'm able to do the test you're looking for.

=IF(AND(A1=A7,B1=B7),C1,IF(AND(A2=A7,B2=B7),C2,IF(AND(A3=A7,B3=B7),C3,IF(AND(A4=A7,B4=B7),C4,IF(AND(A5=A7,B5=B7),C5,IF(AND(A6=A7,B6=B7),C6,0))))))

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 Answers  


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