Too many If then conditions

[Joozh]

I am trying to use a formula where I have about 10 different scenarios for the checking whether a cell in column A contains certain text; based on which I want to type a certain text in the corresponding cell in column B

Is there a simple way rather than using the =IF formula cause currently my IF statement is too long. There was something but it's been a while since I played with Excel and i just can't recall it.

 

[Andrew Poulsom]

Use a lookup table:

http://www.contextures.com/xlFunctions02.html

 

[Joozh]

Thanks Andrew.

Had a look at the site and looks like VLOOKUP will do the trick. Will play with it.