Hi all,
I have the table below on a separate tab on my worksheet. I would like to write a formula in a column on another sheet that basically would say:
If the calls (column A) are between 0-500 and the day is "Normal" (column B) then find the matching # which in this example is 15 (B2).
I would like to use this formula to lookup for all of the listed # of calls and day (normal through L3).
Thanks in advance!
I have the table below on a separate tab on my worksheet. I would like to write a formula in a column on another sheet that basically would say:
If the calls (column A) are between 0-500 and the day is "Normal" (column B) then find the matching # which in this example is 15 (B2).
I would like to use this formula to lookup for all of the listed # of calls and day (normal through L3).
Thanks in advance!
#Calls | Normal | Ops | L1 | L2 | L3 |
0-500 | 15 | 15 | 15 | 30 | 30 |
501-800 | 15 | 15 | 30 | 30 | 30 |
801-1000 | 30 | 30 | 30 | 60 | 60 |
1001-1200 | 60 | 30 | 60 | 60 | 90 |
1201-1400 | 60 | 60 | 60 | 90 | 90 |
1401-2000 | 90 | 90 | 90 | 90 | 90 |