matching data on worksheet
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? |
matching data on worksheet
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? |
All times are GMT +1. The time now is 07:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com