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?