some type of IF function

  • Thread starter WHERE IS THE ANY KEY????
  • 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.
 
J

John Bundy

You can only have 7 if statements, anything more needs to be rethought or
done through VB.
 
S

Spiky

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using ISNA on more than one column within an If Function 2
IF Function formula (I think?) 4
VLOOKUP Function to return values in multipal Columns 6
Nested if function 13
Why doesn't this work ? 2
IF statements with multiple criteria 2
Using IF function 3
Column Function 5

Top