How to Make a cell Display a certain word, when another drop down cell is a certain value (Excel)

[GiantMidget]

the title say it really
any feedback and advice will be greatly appreciated, thanks

 

[SourChipmunk]

=IF(logical_test,[value if True],[value if False])

 

[GiantMidget]

But there are 8 different settings, basically there is a drop down cell which has 1 - 8
which represents candidates, and there is another cell which displays the name of the cadidates. so would a true false still work if there are 8?

 

[PhillyDee]

Look into VLOOKUP
I use it for a price estimator for my laser. Database of values on one page, and the estimator uses a pull down box to get the correct values.

VLOOKUP(C22,Material_Costs!$B$2:$E$230,2,FALSE) is what I have in the cell D22.
It looks up C22 on the sheet Material costs between the cells B2:E320 (No idea why, its a while since I wrote it)
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

Though re-reading it, probably over the top

 

[gillywibble]

Do you want a different word for each value?

You could try a nested IF, although VB would be easier -

=IF(A1=1,"One",IF(A1=2,"Two")) etc.

 

[GiantMidget]

Thanks, a big help