Vlook Question
 

Can you drag a vlookup formula and have the col_index_num follow?

Vlook Question
 

Denise,

One way

=VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE)
Start in column 2 of the table and dragged right becomes column 3 etc
or
=VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE)
same effect dragged down

Mike
"Denise" wrote:

Can you drag a vlookup formula and have the col_index_num follow?

Vlook Question
 

Thank you so much, that worked like a charm...


"Mike H" wrote:

Denise,

One way

=VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE)
Start in column 2 of the table and dragged right becomes column 3 etc
or
=VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE)
same effect dragged down

Mike
"Denise" wrote:

Can you drag a vlookup formula and have the col_index_num follow?

Vlook Question
 

your welcome


"Denise" wrote:

Thank you so much, that worked like a charm...


"Mike H" wrote:

Denise,

One way

=VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE)
Start in column 2 of the table and dragged right becomes column 3 etc
or
=VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE)
same effect dragged down

Mike
"Denise" wrote:

Can you drag a vlookup formula and have the col_index_num follow?