| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two names
I have a worksheet as follows:
Broker Name Broker Code Contact ABC Mtg A123 Bob XYZ Financial B323 Phil Blah Mtg A444 Charles On another sheet I have their production numbers as such: Broker Name Broker Code Loan Number Closed ABC Mtg A123 123456 7/1 ABC Mtg A123 234567 7/2 Blah Mtg A444 987654 7/2 XYZ Financial B323 1230001 7/3 Basicaly what I want to do is this, in the second sheet instead of manually putting in the broker name, I would like it to look at the broker code and find that broker code on the first sheet and put the name of that broker in the second sheet. Seems crazy but it helps me with another part of the wookbook to make sure the names are exactly the same. Can you help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a column of names | Excel Worksheet Functions | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| Comparing Excel # and JPEG Names | Excel Worksheet Functions | |||
| comparing names in a list | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Threaded Mode
