Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
Matching data from one worksheet to another. | Excel Discussion (Misc queries) | |||
Alphabetical Code and matching data to a new worksheet | Excel Discussion (Misc queries) | |||
Find matching data in two worksheet columns | Excel Worksheet Functions | |||
Retreiving font when matching data from one worksheet to another | Excel Discussion (Misc queries) |