If cell contains one of four text values, then input one of three numbers

[aqqs]

Hi all,

I'm trying to create a formula based on the following scenario.

If cell B4 contains the word None, then input the number 0 into C4
Or If cell B4 contains the word Foundation, then input the number 5 into C4
Or If cell B4 contains the word Intermediate, then input the number 10 into C4
Or If cell B4 contains the word Advanced, then input the number 15 into C4

Thanks in advance for your help!

[JohnTopley]

Only A single word?

Use =VLOOKUP(B4, Table, 2,0)



Table is Named range say in columns X and Y

X contains word, y corresponding value

Please Login or Register  to view this content.

or

=VLOOKUP(B4, $X$1:$Y$4, 2,0)

Or

=IF(B4="None",0,IF(B4="Foundation",5,IF(B4="Intermediate",10,15)))

[aqqs]

Perfect, thank you!