Use Index Match with Offset

[westend9876]

I need to retrieve the value from an Index/Match function 1 row above and 3 columns to the right of the Index/Match value. I know how to retrieve the value on the same row. But, how do you retrieve value when not on the same row. I tried using Offset but clearly I'm not successful. Will some please provide an example.

Thanks.

 

[srinidhi]

Kindly attach the sample sheet.

 

[westend9876]

Hi. Here is the sample sheet. Thank you.

 

[mohadin]

Try this

 

[Khalid NGO]

Hi,

Use either:
=INDEX($B$2:$B$4,MATCH($D3,$A$3:$A$5,0),)

=INDEX($B$2:$B$5,MATCH($D3,$A$2:$A$5,0)-1,)

Regards,