| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Sheet names in formulas
glad it helped
-- Don Guillett SalesAid Software "bsullins " wrote in message ... Works great, here's the end result VLOOKUP(VLOOKUP(emplnk,EmplDB!$A:$Z,2,0),INDIRECT( VLOOKUP(emplnk,EmplDB!$A:$ Z,9,0)),MATCH(A9,INDIRECT(VLOOKUP(emplnk,EmplDB!$A :$Z,10,0)),0),0) VLOOKUP(emplnk,EmplDB!$A:$Z,2,0) = Employee ID VLOOKUP(emplnk,EmplDB!$A:$Z,9,0) = Named Range VLOOKUP(emplnk,EmplDB!$A:$Z,10,0) = Named Range Now depending on what 'level' the agent is will tell the formula what ws to lookup from. --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging formulas with sheet names | Excel Discussion (Misc queries) | |||
| Using Sheet names in formulas | Excel Worksheet Functions | |||
| Sheet names used in formulas | Excel Discussion (Misc queries) | |||
| replacing just the sheet names within formulas | Excel Worksheet Functions | |||
| Locking Sheet names in formulas | Excel Worksheet Functions | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
