Get cell value from another cell adjacent to particular matching cell

[rahulbuddy]

Hello Guys,

I am making an excel file where, I want to retrieve a cell value from another cell next to that particular date.

So I have a exchange rate table with 2 columns, where in Column1 I have dates and in Column2 I have currency exchange rate for that particular rate. Lets say I have this data for 6 months.

In another column, I want to fetch that exchange rate value only for a particular date. Kindly look at image attached. Any help is much appreciated.

Thanks and Regards,
Rahul.

.

 

[jasonb75]

Welcome to Mr Excel

You can do that with a basic LOOKUP formula, assuming that A1 is the top left corner of your picture, you could try

=LOOKUP(E5,$B$4:$B$18,$C$4:$C$18)

I've also assumed that you have proper dates in both tables. The left alignment in the first table suggests that they could be invalid text strings, in which case the formula will not recognise them correctly.

 

[rahulbuddy]

Welcome to Mr Excel

You can do that with a basic LOOKUP formula, assuming that A1 is the top left corner of your picture, you could try

=LOOKUP(E5,$B$4:$B$18,$C$4:$C$18)

I've also assumed that you have proper dates in both tables. The left alignment in the first table suggests that they could be invalid text strings, in which case the formula will not recognise them correctly.

It works..

Many many many thanks. God bless you dear.