Hello,
I am trying to augment the column index number of my Vlookup formulas, while I am copying them in the same column: the column index number needs to be +1 but I am copying the formulas under the original formulas, so in the same column. How can I do this?
Regards,
Karel
G'day and welcome to the forum,
Not sure I fully understand what you mean but I'm going to have a crack at the question before I go to bed.
=VLOOKUP(lookup_value,table_array,column()+1,[range_lookup])
Your answer is in the red.
Eg if you are writing the formula =column()+1 in Column B the number you'll return will is 3. Cos B is the 2nd column in the excel and you plus one equals three.
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Hey,
This would help if I copy the formulas in the column next to the original column but I want to copy the formulas unther the original so in the same column. With the idea to use 'Column()+1', the column index number would remain identical as before...
Did I explain myself clearly?
Regards
???
What's in the vlookup formula to make it change went you copy drag the formula down ????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks