Hlookup 3 criteria??

J

jc9972003

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top