| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching name from one worksheet to another
On Sheet1 I have a long list of names in column A along with the
associated supervisor in column B. Column C is for the group number. On Sheet2, I have another, shorter list of names (supervisors) in column A with their group numbers in column B. In column C of Sheet1, I want to return the group number from matching supervisor in column B on Sheet 2. I've looked at Match and VLookup, but nothing seems to work. Thanks. Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Search & match more than one worksheet and matching cells. | Excel Worksheet Functions | |||
| Retreiving font when matching data from one worksheet to another | Excel Discussion (Misc queries) | |||
Threaded Mode
