If statement

[andrewm]

i am not sure if i use if statement with the or etc.

cells a1
b2


in cell c2 - if cell a1 has the name "andrew" i want cell c2 to be "monday"
if cell a1 has the name "john" i want cell c2 to be "tuesday"
if cell a1 has the name "george" i want cell c2 to be "wednesday"


thanks

andrewm

[nuver]

Hello Andrew
This is the formula that I would use. Hope this helps.

=IF(A1="andrew","Monday",IF(A1="John","Tuesday",IF(A1="george","Wednesday","")))

[foxxkat]

hi andrew, nuver's solution will work fine.
but if you have a long list of names you may want to use VLOOKUP

rgds,