Hi,
I have a sheet with phone numbers, and on a separate sheet in the same workbook I have call data. What I need is a formula to search the Call Data sheet for the phone numbers from the Numbers sheet, and retrieve the information from the column (Dest_Init - column G) which shows when a call was first attempted for that particular number (i.e. 18/07/2016 18:04:21).
I have been using Vlookup, which in most cases is fine as an outbound call is made on the first attempt, but there are some cases when a call has been queued but the outbound call was never made so the cell is blank (in the Dest_Init column). I need to search for the first non-blank value for each phone number.
I hope this makes sense! I think I need an Index Match formula (maybe??) but I could do with some guidance. I have attached a sample, but the real data has many more rows and a few more columns with information that is not relevant to this query.
Thanks!
Bookmarks