| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Cell Fill-in from Spreadsheet Database
I have a spreadsheet that has LastName/FirstName in cells A1 and B1
respectively. In C1 I want to put a formula that looks at another spreadsheet set up as a database to pull the last 4 numbers of the person's SS#. Since there could be more than one person with the same last name, the formula would have to reference both cells A1 and B1 to make sure it got the correct SS#. I am just not sure this is doable. Thank you for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i locate the cell linking to another spreadsheet | Excel Discussion (Misc queries) | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
| Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
