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
formula to return a name from one column to another (2003SP3
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
formula to return a name from one column to another (2003SP3
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: formula to return a name from one column to another (200
The word Frozen should be enclosed in quotes:
=IF(F5="Frozen","Frozen",0)
=IF(F5="Frozen","Frozen",0)
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: formula to return a name from one column to another (200
Here is an example...
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: formula to return a name from one column to another (200
Thanks Hans & Rudi
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin