In the formula,
=VLOOKUP($A7,References!$A1:$B15,2,FALSE),
I drag it to the adjacent cell (right ward) and wish to change it to
=VLOOKUP($A7,References!$A1:$B15,3,FALSE),
i.e. the column index should increment.
How can i achieve this?
In the formula,
=VLOOKUP($A7,References!$A1:$B15,2,FALSE),
I drag it to the adjacent cell (right ward) and wish to change it to
=VLOOKUP($A7,References!$A1:$B15,3,FALSE),
i.e. the column index should increment.
How can i achieve this?
Hi and welcome to the forum!
For a start, I think you need to re-check what you posted, since there are only two columns in A1:B15 so referencing a third would simply result in error!
Can you clarify?
Regards
ya right... let there be 10 columns.. and i wish to increment the column index from 2 to 3....
i.e.,
=VLOOKUP($A7,References!$A1:$J15,2,FALSE)
Ok, so your first formula should be:
=VLOOKUP($A7,References!$A1:$J15,COLUMNS($A:B),FALSE)
Regards
thanks...i shall try now and get back to u...
It worked...and what i have learnt is the usage of =columns() command...
Thanks..
You're welcome. Glad to have helped.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks