ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hlookup 3 criteria?? (https://www.excelbanter.com/excel-worksheet-functions/448542-hlookup-3-criteria.html)

[email protected]

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

Spencer101

Quote:

Originally Posted by (Post 1610923)
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

Could you post an example workbook with dummy data and a before and after view? Makes it far easier to understand your requirement that way.


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com