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
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