Range Lookup w/multiple criteria

[lfcreds11]

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!

#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

 

[lfcreds11]

I was able to correct the error! Thank you so much for all your help!!!