1. Insert Names/ Define
e.g.
EmpTable for the range Hidden!a2:k134
EmpNames for the range Hidden!a2:a134

(you can make this "dynamic range names"
google on that term should give you some examples.


2. in a free cell on your "input sheet"
e.g. C5

Data/Validation
Allow LIST
Check INCellDropdown
Source =EmpNames (name as defined above, be sure to include the =)

3. Enter your VLookup Formulas in C9: C29
=Vlookup($c$5,EmpTable,1,0)

Done.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


alymcmorland wrote :


how would i go about doing that?