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,INDIREC T(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 wha
ws to lookup from

--
Message posted from http://www.ExcelForum.com