Thread
:
Multiple IF values
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Multiple IF values
Look in the help index for VLOOKUP or just LOOKUP
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Murph" wrote in message
...
Trying to assign values to certain text in a column
K2 =City
I want L2 to show a number reference for that city.
If K2 = Columbus then L2 = 1
If K2 = Denver then L2 = 2
I went to this.. and it failed
=IF(K2="Toledo",1,0):IF(K2="Columbus",2,0): IF(K2="Cleveland",3,0)
Help?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett