Index/Match

[Khalil Lakhani]

Hello Everyone!
I am trying to achiwve desired results by using Index/Match combo.
Attached is the sprdsht with example -
In essence, I am trying to fetch matching/corresponding date for Column B on sheet 2 by matching the column D on sheet 1 - I will need ColumnB and C on sheet 2 --
Please help me achieve this feat -

Thanks,
K.

 

[Luke M]

In B2:
=INDEX(Sheet1!B$2:B$17,MATCH($A2,Sheet1!$D$2:$D$17,0))

Copy down as needed, and to the right once, to return data from both cols B and C.

 

[Khalil Lakhani]

In B2:
=INDEX(Sheet1!B$2:B$17,MATCH($A2,Sheet1!$D$2:$D$17,0))

Copy down as needed, and to the right once, to return data from both cols B and C.

Smooth!! Thanks Luke!