some type of IF function
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. |
some type of IF function
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. |
some type of IF function
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) |
All times are GMT +1. The time now is 08:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com