Multiple =IF

[Dom2012]

Hi,

I've been trying to figure this out to no avail.

I want a cell to return one of seven values contingent upon another cell having one of another seven values. Example:-

If A1 = A then B1 should = HORSE
If A1 = B then B1 should = GOAT
If A1 = C then B1 should = DOG
If A1 = D then B1 should = CAT
If A1 = E then B1 should = MOUSE
If A1 = F then B1 should = DUCK
If A1 = G then B1 should = BEETLE

What formula would I put in cell B1 to get this result?

Many thanks,
Dom

 

[T. Valko]

Hi,

I've been trying to figure this out to no avail.

I want a cell to return one of seven values contingent upon another cell having one of another seven values. Example:-

If A1 = A then B1 should = HORSE
If A1 = B then B1 should = GOAT
If A1 = C then B1 should = DOG
If A1 = D then B1 should = CAT
If A1 = E then B1 should = MOUSE
If A1 = F then B1 should = DUCK
If A1 = G then B1 should = BEETLE

What formula would I put in cell B1 to get this result?

Many thanks,
Dom

See this...

http://contextures.com/xlFunctions02.html

 

[Aladin Akyurek]

Hi,

I've been trying to figure this out to no avail.

I want a cell to return one of seven values contingent upon another cell having one of another seven values. Example:-

If A1 = A then B1 should = HORSE
If A1 = B then B1 should = GOAT
If A1 = C then B1 should = DOG
If A1 = D then B1 should = CAT
If A1 = E then B1 should = MOUSE
If A1 = F then B1 should = DUCK
If A1 = G then B1 should = BEETLE

What formula would I put in cell B1 to get this result?

Many thanks,
Dom

Try...

=INDEX({"HORSE","GOAT","DOG","CAT","MOUSE","DUCK","BEETLE"},MATCH(A1,{"A","B","C","D","E","F","G"},0))

Or

=INDEX(AnimalRange,MATCH(A1,LetterRange,0))

where AnimalRange stands for a range housing animals and LetterRange the corresponding letters.

 

[Dom2012]

Thanks for the quick response. That was great. And it works!

 

[Aladin Akyurek]

Thanks for the quick response. That was great. And it works!

You are welcome. Thanks for providing feedback.