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