You can only have 7 if statements, anything more needs to be rethought or
done through VB.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"WHERE IS THE ANY KEY????" wrote:

Could someone please help with the formula for having a seperate column
return a value based on a drop down?? Column "B" is linked to column "K"
with all the employee names. I would like Column "C" to return the Value
from Column "L". There will be approximately 100 employees, and it seems
that anything over 8 or 9 is causing problems.