Barbara,

=VLOOKUP($A1,Sheet2!$A$1:$F$100,Column(),False)
or
=VLOOKUP($A$1,Sheet2!$A$1:$F$100,Column(),False)

HTH,
Bernie
MS Excel MVP


"Barbara" wrote in message
...
It's working!
One more question, How do I copy without having to go in and change the
first cell referance back to A1 in each cells formula?
Barbara