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)