| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One partial table, one master table - update the partial
I've got a listing of 3000 personnel. Personnel in column A, supervisors in
column B. In a separate worksheet, I have a listing of 400 personnel in column A. Same names in column A, sheet 1 as in column A, sheet 2, just a shorter listing in sheet 1.(smaller worksheet). Short list: Sheet 1 Master list: Sheet 2 How do I get EXCEL to compare sheet 1 with sheet 2, and fill in the appropriate supervisor in sheet 1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| partial match in vlookup with table array | Excel Worksheet Functions | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| changing table cells colours using a master table | Excel Discussion (Misc queries) | |||
| Partial correlations | Excel Discussion (Misc queries) | |||
| Pivot Table sum option - Only partial info and repeating | Excel Discussion (Misc queries) | |||
Threaded Mode
