• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup question

H

Howardc

New Member
I have the following Vlokup formula


VLOOKUP(A5,$L$11:$U$171,10,FALSE)


I would like to change the Vlookup to combine with another formula to lookup at the column offset number for Col U starting from Col L i.e 10 instead of having to manually count the cfol offset in this eg ,10


Your assistance in this regard is most appreciated
 
If you always want to pull from the last column in array:

=VLOOKUP(A5,$L$11:$U$171,COLUMNS($L$11:$U$171),FALSE)


If you want the column reference to just be dynamic via a cell reference or something:

=VLOOKUP(A5,$L$11:$U$171,$B$2,FALSE)
 
You must log in or register to reply here.
Back
Top