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...