LinkBack URL
About LinkBacks
Is there a way to have the "col_index_num" change automatically as you copy a lookup across columns?
=VLOOKUP(A1,Sheet2!$A$1:$D$20,1,false)
I'd like the 1 reference to change to 2, 2 to 3 and so on as I carry my formula over.
Thanks
Is there a way to have the "col_index_num" change automatically as you copy a lookup across columns?
=VLOOKUP(A1,Sheet2!$A$1:$D$20,1,false)
I'd like the 1 reference to change to 2, 2 to 3 and so on as I carry my formula over.
Thanks
Last edited by ExcelAteMyHomework; 06-01-2012 at 12:13 PM.
Hi,
Try,
=VLOOKUP(A1,Sheet2!$A$1:$D$20,COLUMN(A1),false)
HTH,
Steve
Wow such an easy fix and I never thought of that lol. Thanks Steve!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks