Hello,
I have a table which consist of 8 columns , the first is time in 30 mins slots followed by Sunday, Monday , days of week. All these cells contain phone arrival pattern %. Side of that I have another table which has 3 rows , first is dates & days from Jan to March with the 3rd row having total phone call expected on that date.
I would love some pointers on which formula to use so that I can use the phone arrival pattern data to convert the daily call volume over the respective days and the formula would check for the days for example only Monday's data in arrival patterns will be used for Monday in phone calls table
Have used VLOOKUP and this IF formula, IF(C$5=$L$4,($C$6:$C$32)*$L$5,0) but it does not work if I drag over the other days. Would love some guidance on which formula can used so that it can be dragged across all rows to get the results , not looking for an exact formula , just some pointers . Am enclosing a sample workbook with data
Thanks in advance
Bookmarks