My lookup is below. Is there a way to return a result that is 2 rows higher than the existing match?
Let's say my match was found in Colunm B and I am returning 1st colunm, could I return 2 rows higher than my match?
I tried offset((VLOOKUP("T"&$AI5,ENTRY!$B$2:$B$2001,1,FALSE)),2,0)
with no success.
=(VLOOKUP("T"&$AI5,ENTRY!$B$2:$B$2001,1,FALSE))
Thanks
Let's say my match was found in Colunm B and I am returning 1st colunm, could I return 2 rows higher than my match?
I tried offset((VLOOKUP("T"&$AI5,ENTRY!$B$2:$B$2001,1,FALSE)),2,0)
with no success.
=(VLOOKUP("T"&$AI5,ENTRY!$B$2:$B$2001,1,FALSE))
Thanks