I just wanted to thank you Dan and everyone who responded. Your solution
worked great! I detest duplication of effort and we were hand entering
values into a spreadsheet from a report that could have been imported into
excel. We were just missing the data from standard columns. This saves us
so much work. Thanks everyone!

Susan

"dan dungan" wrote:

Hi Susan,

try changing the col_index_num and pasting the formula in the next
column and copy down.


In worksheet B, In column b:

=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,2,FALSE)

Column C put:
=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,3,FALSE)

Column D put:
=VLOOKUP(SheetA!$A$1,SheetA!$A$1:$F$10,3,FALSE)


etc.

Dan