| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookups across worksheets
I need to consolidate some information, using several worksheets in one file. Here's an idea of what I need to do: WORKSHEET 1 - [/b] _FIRST_|__LAST__|_COMPANYID_|_LOCATIONID_ BILL | SMITH | 1 | 3 JEN | JONES | 2 | 1 [b]WORKSHEET 2 - _Company_ID_|__Name_ 1 | Acme 2 | Widgets 3 | Bucky's WORKSHEET 3 - _LocationID___|__Name_ 1 | New York 2 | Paris 3 | Rome I need to come up with a set of formulas that give me the following result: WORKSHEET 1 - _First__|_Last__|_CompanyID_|_LocationID_ Bill | Smith | Acme | Rome Jen | Jones | Widgets | New York Any ideas would be greatly appreciated!! Jessica -- sixpence668 ------------------------------------------------------------------------ sixpence668's Profile: http://www.excelforum.com/member.php...o&userid=25472 View this thread: http://www.excelforum.com/showthread...hreadid=389209 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Worksheets | Excel Discussion (Misc queries) | |||
| Merge Worksheets | Excel Worksheet Functions | |||
| Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
