some type of IF function

  • Thread starter Thread starter WHERE IS THE ANY KEY????
  • Start date Start date
W

WHERE IS THE ANY KEY????

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.
 
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.
Click to expand...

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