formula to return a name from one column to another (2003SP3

[steveh]

Hi all

I have a column F5:F46994 which will contain one of 5 words, for example Frozen or Ambient I want to make an adjacent 5 columns and in the first one G5:G46994 I would like to put in a formula that says =IF(F5=Frozen,"Frozen",0) but I get a #NAME error, I thought a VLOOKUP might do it but I couldn't get that to work either. I then thought that I could do it by using a LOOKUP from an intermidiary cell so in Cell P5 I typed the word Frozen and then used the formula =LOOKUP($P$5,F5:F46994) but that is returning Frozen in every column field. Help much appreciated

[HansV]

The word Frozen should be enclosed in quotes:

=IF(F5="Frozen","Frozen",0)

[Rudi]

Here is an example...

[steveh]

Thanks Hans & Rudi