If statement with 2 reasons

I would like to construct an if statement that is If cell A2=stop return x, if A2 =go return y, if A2=bold return z (this would have 9 ifs). The only exception would be if B2=Folly then A2=stop return b, if A2 =go return c etc. I have these values on a seperate sheet if that helps in column F & H. Thanks

Post a sample of ur sheet, including the value table.

You could do this most easily with some sort of LOOKUP formula, e.g. if your separate sheet is called data and you have your 9 possible values for A2 in E1:E9 (stop,go etc.) and the corresponding values to be returned in F1:F9 [ or alternative values when B2=Folly in H1:H9]

Then you can use the formula

=VLOOKUP(A2,data!E1:H9,If(B2="Folly",4,2),0)

Does this help BigBas? Thanks

It is very hard to follow the example the you posted. Im not sure how sheet 1 relates to sheet 2 at all. I have set up a sample of one of the methods of doing it. Obviosuly, you will have to adjust the values to suit.

Your list is on the LIST page, and you enter your values on the entry page.

BigBas, your patience is much appreciated. It looks great except when it finds the word "folly" in column B on the entry list it should return the values in a different column from the list sheet. So in this revised example if on the list page in column C there was a B in C2, a C in C3 and a D in C4 if the word folly is in column B those values or letters would be returned. So in the example you sent me on the entry page C5 would read B, C6 would read C and C7 would read D. Thanks in advance

BigBas, the only time those other values/words should be returned in when folly is in the cooresponding row in column B.

This solves the problem above.
//Ola

I increased the table size to from 2 to 3 columns and added the logic below:
(B5="folly") -->False, 1*False -->0
(B7="folly") -->True, 1*True -->1

Incredible, thanks to all!!!!!

Okay, now I need to push the envelope. How about if I wanted to add that if "cat" and "dog" are in column C on the entry page they would also reference column D on the list page. I tried many options but could make no headway. Thanks

I kept pushing and finally figured it out +1(c2="cat") etc does it. Once again thanks to all!!!!!!!!!!!