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/