set up automatic currency detection in another column

set up a table on a new sheet listing each of the companies and their currency, then use a VLOOKUP to select the appropriate currency.

For example:

Please Login or Register  to view this content.

Select all the cells in the table and give the range a name, for example, currencies.

Then, the formula for a value in cell A2 would be:

Please Login or Register  to view this content.

Regards

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I have attached a Dummy Workbook

see attached workbook

Originally Posted by TMShucks

see attached workbook

Hi Thanks,

It was really helpful, How do you set up auto select of currency if the company names are in the form of a list.

Please see attachment.

I think that, strictly speaking, this should be a new thread as your original question has been answered.

Anyway, see the attached workbook.

Just give the list of companies, which you already have as part of the currencies table, a name ... Companies, for example. Then make the Data Validation source "=Companies"

Regards

Sorry, my fault ... see attached.

The easy way to name a (simple) range is to select the cells and then type a name in the Name box ... just above and to the left of the column headings.