Use the elementary Vlookup().

Sheet1 -
Column A = invoice number - from A2 to A100
Corresponding data in matching rows - B2 to Z100

Sheet2 -
Enter invoice number in A2
Enter this formula in B2:

=VLOOKUP($A2,Sheet1!$A$2:$Z$100,COLUMNS($A:B),0)

Copy across to Z2.

Then, you can select B2 to Z2 and copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"makega" wrote in
message ...

More thought on this...

B1 searches a specified column on a different worksheet for the value
in A1. If that value is found in the column on the other worksheet, B1
populates itself with the value in the cell column to the right of
wherever that value was found on the other worksheet.

Is that more clear? Was reading my previous post and it was rather
confusing.

Thanks in advance. I've found so many answers to my questions here
this the the firts time I've actually had to post one!


--
makega
------------------------------------------------------------------------
makega's Profile:
http://www.excelforum.com/member.php...o&userid=29876
View this thread: http://www.excelforum.com/showthread...hreadid=495805