route217
asked on
vlookup excel 2007 to changes as formula is dragged across columns
Hi Expert's
is it possible to write a vlookup formula...so as you drag the formula across from A2:Z2 the column reference changes to the next one along..
so =if(isna(vlookup(d3,d45:j5 5,3,0)),"" ,(vlookup( d3:j55,3,0 )))
So the 3 changes. ..
is it possible to write a vlookup formula...so as you drag the formula across from A2:Z2 the column reference changes to the next one along..
so =if(isna(vlookup(d3,d45:j5
So the 3 changes. ..
That is the default behavior. Insert the formula in one cell, as you drag it vertically the column references will get updated.
ASKER
So...default. .meaning. ..no it cannot be done??
And firstly thanks for the feedback Macro Shadow
And firstly thanks for the feedback Macro Shadow
No, it can be done and in fact it will be done automatically when you drag your formula vertically.
ASKER
Sorry. ..I am looking for horizontal across. .
Sorry that's what I meant.
ASKER
Apologies. ...the 3 changes to 4 the next column along...
Isn't that what you want?
ASKER
Yes I do....I have just written the vlookup and dragged the formula across from d2 to f2 and column reference has stay fixed at 2.....
Please upload a sample.
ASKER
Worked it out....use column(b1),false. And drag
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. ...