VLOOKUP paste

[pinmaster]

Hi,
Is it possible to write a VLOOKUP formula so that when it is paste
across, it would update the column number automatically?
For example: =VLOOKUP($B5,range_name,2,0) when pasted in the nex
column would become =VLOOKUP($B5,range_name,3,0)

thanks

 

[Frank Kabel]

Hi
try:
=VLOOKUP($B5,range_name,COLUMN(B:B),0)

 

[Gord Dibben]

One method....

Select 4 cells in a row then type this in active cell.

=VLOOKUP($B5,range_name,{2,3,4,5},0)

CRTL + SHIFT + ENTER to array-enter.


Gord Dibben Excel MVP