D
Denise
Can you drag a vlookup formula and have the col_index_num follow?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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
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
D
Denise
Thank you so much, that worked like a charm...
Mike H said: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
M