| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching and entering data
Hi, will try to explain my problem as best as I can.
I have 2 worksheets. Each worksheet has in column A a list of unique customer numbers. Sheet 1 has 75000 rows AND 4 extra columns of data and sheet 2 has 63000 rows. What I need to do in sheet 2 is: If customer number in Sheet 2 has a corresponding customer number in sheet 1I need to insert the corresponding 4 cells of data aginst the customer number in sheet 2 also remember the row numbers in sheet 1 & 2 do not correspond! Please help :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering and matching a value in a list | Excel Discussion (Misc queries) | |||
| entering matching data for line charts | Charts and Charting in Excel | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Workbook for entering POs and matching and paying invoices | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
