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.

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.

On Sep 15, 1:46 pm, WHERE IS THE ANY KEY???? <WHERE IS THE ANY
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.

Use a VLOOKUP instead of IF.
=VLOOKUP(B2,$K$2:$L$100,2,FALSE)