Dear friends,

I have a worksheet with 4 columns, i.e. in Column1 I record the date,
Column2-4 I record the exchange rates in JPY, GBP and USD.

I need, in a different worksheet to enter the date and Currency and to:
1. Show me in a nearby cell the exchange rate of that date and currency and
2. To highlight the corresponding date and exchange rate of that currency in
the first worksheet.

Shall I need some coding or?

Any ideas will be highly appreciated.

Thanking you in advance,

GeorgeCY