I would have to see a lot more info and/or a sample wb but maybe I can help
your basic formula with this idea

=VLOOKUP(L3,if(l2="Certified 10 Month",Ten,if(l2= "All 12
Month",StartDate)),2)
You could even use CHOOSE or LOOKUP instead of the IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Denise" wrote in message
...
I created a formula to reference a drop-down menu & then based on the
value...get value from the selected Lookup Table (column #2). Here's the
formula:

=IF(L2="Certified 10 Month",VLOOKUP(L3,Ten, 2), IF(L2="All 12
Month",VLOOKUP(L3,StartDate, 2), IF(L2="Non-Certified 10
Mth",VLOOKUP(L3,NonCert, 2), IF(L2="Certified 11 Month",VLOOKUP(L3,Eleven,
2),IF(L2="Haskell (Year-Rnd)",VLOOKUP(L3,Haskell, 2),IF(L2="Certified
9-Month",VLOOKUP(L3,Nine, 2))))

What I ultimately need this formula to do is to search the chosen lookup
table column based on the entered date and count forward from that date
the #
of cells with text in them ("Holiday") and then subtract that from the
value
it retrieved. I am trying to get an accurate count of days an employee
will
work - holidays.

Any help appreciated~