Hlookup 3 criteria??
A B C D E F
Outbound Inbound Internal None Specific None Handles Avg. Active Dur Handles Avg. Active Dur. Handles Avg. Active Dur 2 2:52 7 4:10 10 1:51 4 3:51 9 2:31 5 3:45 This is what my export looks like I would like a waty to H lookup "Outbound", "None", "Handles", "Avg, Active Dur" and for the formula to return all the values below Handles and Avg Active Dur. In This case it would be Outbound Internal Handles Avg Act Durantion Handles Avg Act Durantion 2 2:52 10 1:51 4 3:51 5 3:45 Keep in mind Oubound, Inbound, Internal cover 6 columns each None and Specific takeup 2 columns (The way my source exports) and below that Handles and avg act duration takeup one column each. Kinda complicated I hope someone can help me |
Quote:
|
All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com