using an array

[TimlmiT]

Gurus,

I have a project to have a form translate several different languages. I started out using a list to select the language. Based on that input and a helper cell, the headings would change to the appropriate language. While there are 60+ headings, I am wondering if there is an easier way of doing this without having such a long formula in each cell.

Please Login or Register  to view this content.

I've looked into hlookup but it doesn't seem to be the right code because I don't have a second match input..

Also, I want to keep this macro free.

Thanks in advance.

Tim

[AliGW]

Do you consider that a long formula? It certainly isn't.

[sweep]

Hi,

You could use the Index function perhaps....

Please Login or Register  to view this content.