try the vlookup, Index and Match which should do what you want.
if not, pls post back with a sample of your source data and expected result

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Frank T" wrote:

I am trying to match data from column a to rest of worksheet, (b-av), 22
columns.
Weekly, the office sends an inventory workbook containing approx 5000 rows
and columns from a to av (22 columns).
I then insert a new column (A) and paste item numbers I want to find in the
rest of the worksheet, columns b-av, and 500 rows.
I want to match my selected items from column a to all in the information in
the rest of the worksheet of 5000 rows and 22 columns.
How do I do this?