VLOOKUP paste

P

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
 
G

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
 
Top