Vlookup Offset Row?

[jmersing]

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

 

[NBVC]

Try

=Index(ENTRY!$B$2:$B$2001,Match("T"&AI5,ENTRY!$B$2:$B$2001,0)-2)

 

[jmersing]

Thanks! I actually had to change it to +2, but the end result was the desired effect.

One more question if you don't mind, is it possible to offset the result by colunm also?

i.e. After a match is found I'm get-ting the result of 2 rows lower, what if I wanted 2 rows lower but 2 colunms to the right? Is that possible?

Thanks again

 

[NBVC]

Try:

If you mean column C, then

=Index(ENTRY!$B$2:$C$2001,Match("T"&AI5,ENTRY!$B$2:$B$2001,0)+2,2)


If you mean column D, then

=Index(ENTRY!$B$2:$D$2001,Match("T"&AI5,ENTRY!$B$2:$B$2001,0)+2,3)

 

[jmersing]

Sweet!

I was changing the range on both parts of the formula istead of just the first one.

Thanks again!