OK, Ill do my best to describe what I am trying to achieve, all help appreciated, so lets set the scene!:

I have put together a table for viewing various exchange rates (roughly 30 rows by 30 columns to be precise) with a view to being able to automatically extract the correct rate from it in conjuction with a combobox as the means for doing this.

Worksheet 1 contains a 'select the currency from' combobox list and a 'select the currency to' combobox list

Worksheet 2 has the exchange rate table in it.

What I want to achieve is when an exchange rate is selected from the 2 combo boxes on worksheet 1 it triggers a formula to go to worksheet 2, read and publish the appropriate rate but I have run out of ideas to do this, help please!!

The logic I have been trying to apply is to name each of the rows and colums of figures in the table (Lets say for example the row of USD Dollar rates, USD and the column of UK Pound Rates, UKP) there will then be only one instance where those ranges contain the same cell, ie where they cross and that would give me the rate i need :)

I would use the comboboxes to give me the required currencies in the linked cells and then use the answers in the linked cells in someway to read the correct rate from the currency table.

Help please.

Thanks