IF formula query

[Calamity98]

Hello there

I need to create a list where in one column I enter a code and the next column will automatically be populated with the full description i.e.

A1 = MIE
B1 = Made in Egypt

I am currently using a formula in B1 (set out below) which I have used in the past for a spreadsheet whereby B1 is a currency however when I use it for my new spreadsheet whereby both A1 & B1 are both text, I keep getting a ‘#NAME’ error. I have tried formatting both columns as ‘general’ or ‘text’ to see if this makes a difference but it hasn’t.

The formula I have been putting in B1 is:-

=IF(A1="MIE",Made in Egypt,(IF(A1="MIF",Made in France,(IF(A1="MIC",Made in Cyprus)))))

Any help would be much appreciated.

Thank you

[Pete_UK]

You need to put double quotes around the text strings, like this:

=IF(A1="MIE","Made in Egypt",IF(A1="MIF","Made in France",IF(A1="MIC","Made in Cyprus")))

I've removed some redundant brackets. If you have many more codes, then you could use VLOOKUP with a simple table of codes and meanings, and avoid multiple IFs.

Hope this helps.

Pete

[Calamity98]

Thanks so much Pete. I did have quite a few more to enter so I took your advice and set up a VLOOKUP instead and it works a treat. Has speeded things up no end.

Have a great afternoon

[newdoverman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.