Need help with more than 8 IFs

[smarinaj]

Hi all!

This is the situation I have. Everyweek I receive a spreadsheet containing a lengthy list of destinations in English that I need to translate into Spanish. I would like to create a formula that will take the destination name from column A of the spreadsheet and compare it against a table where I have a column for the destinations in English and a column for the translation into Spanish. The formula will place the correct translation into column B of the weekly spreadsheet.

Thanks so much for your suggestions.

Sandra

 

[MrKowz]

Welcome to the forums!

This sounds like a great place to use of VLOOKUP. Can you please give an example of your data, as well as your input and desired outcome?

 

[smarinaj]

Thanks for your quick reply.

The weekly spread sheet contains only 1 column with about 200 names of destinations. This list changes everyweek. For instance:

Column A:
Atlantic Beach, North Carolina
Avon, Colorado
Branson, Missouri
Ozark Mountains, Arkansas

I already have a spread sheet with the names of all possible destinations in Column A and their translation in Colum B. For example:

Column A:
Paris, France
Atlantic Beach, South Carolina
Miami, Florida
Pocono Mountains, Pennsylvania


Column B:
París, Francia
Atlantic Beach, Carolina del Sur
Miami, Florida
Montañas Pocono, Pensilvania

What I want to accomplish is the following. Once I get the weekly spreadsheet, I want to have a formula in Column B of that spreadsheet that sees the destination name in Column A and gives me the correct translation in Column B, based on the translation table that I already have.

Let me know if you need me to provide you with more details. I don´t have experience in this forum.

Thanks so much.

Sandra

 

[MrKowz]

Try this - column B in Sheet1, below, is generated based off of the table in Sheet2 (which is pictured below the first table):

Excel Workbook
	A	B
1	Destinations	Translations
2	Atlantic Beach, South Carolina	Atlantic Beach, Carolina del Sur
3	Pocono Mountains, Pennsylvania	Montaas Pocono, Pensilvania
4	St. Louis, Missouri	Translation Not Found
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B2	=IF(ISERROR(VLOOKUP(A2,Sheet2!$A$1:$B$4,2,FALSE)),"Translation Not Found",VLOOKUP(A2,Sheet2!$A$1:$B$4,2,FALSE))

Excel Workbook
	A	B
1	Paris, France	Pars, Francia
2	Atlantic Beach, South Carolina	Atlantic Beach, Carolina del Sur
3	Miami, Florida	Miami, Florida
4	Pocono Mountains, Pennsylvania	Montaas Pocono, Pensilvania
Sheet2

Excel 2003

 

[smarinaj]

Dear MrKowz,

It works perfectly. Thanks so very much!

Sandra