Look up cell in an array and then return the value of a cell in that same array relative to the

[BKGLTS]

Hello,

I need to look up a cell in an array, and then return the value of a cell in that same array relative to it.

For example:

A1 = 1/1/2018 B1 = 2/1/18 C1 = 3/1/18 D1 = 4/1/18 E1 = 5/1/18
A2 = 2/1/18
A3 = 2
A4 = 4/1/18

A4 was found by looking up A2 in the A1:E1 array (which in this case is B1), and then returned the value of the cell that is 2 columns to the right (as indicated by A3).
Can someone please help me with this formula?
It seems a little complicated requiring a few different function types.
I need the formula for A4.

Thank you!
B

 

[Frank_Excel]

Hi B,

Please check if the following formula works for you! COpy and paste in A4.

=INDEX(A1:E1;MATCH(A2;A1:E1;0)+2)

Kind Regards,
Frank

 

[Peter_SSs]

.. 2 columns to the right (as indicated by A3)

Welcome to the MrExcel board!

Given the above, one small change to Frank's suggestion

=INDEX(A1:E1,MATCH(A2,A1:E1,0)+A3)

 

[BKGLTS]

Thank you gentlemen.
This is perfect!

 

[Peter_SSs]

Thank you gentlemen.
This is perfect!

Glad it worked for you.