# Vlookup based on Moving Target range

#### east3rd

##### New Member
Hi everyone,
Pulling my hair out today trying to figure this one out! I have a large reference doc where the given value I'm trying to locate can be found anywhere between columns J - U. From there I need to lookup the value in column AA, hence my vlookup range is somewhat dynamic. I am already using the following formula to locate the column number, for example:

=COLUMN(INDEX('[PPV_CRTC 2018-2019.xlsx]Movies'!J\$1:U\$1,SUMPRODUCT(MAX(('[PPV_CRTC 2018-2019.xlsx]Movies'!\$J\$2:\$U\$520=A2)*(COLUMN('[PPV_CRTC 2018-2019.xlsx]Movies'!\$J\$2:\$U\$520))))-COLUMN('[PPV_CRTC 2018-2019.xlsx]Movies'!\$J:\$J)+1))

The above formula returns a value (12) which equates to column "L" (for example). Given I can locate the "starting" point, how do I now lookup the value in column AA? As always, your help is appreciated.
Thx

#### Snakehips

##### Well-known Member
Can you not then use INDEX(AA) MATCH("L") ?

#### east3rd

##### New Member
Thanks for the quick response - could you expand on your suggestions? Perhaps my last formula lead you to believe I know more about Excel then I do ; )

Can you not then use INDEX(AA) MATCH("L") ?

#### Snakehips

##### Well-known Member
As far as I understand what you are trying to acheive then, like.....

#### east3rd

##### New Member
Perfect!
Thank you so much