Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multipl HLOOKUP/VLOOKUP Criteria | Excel Discussion (Misc queries) | |||
HLookUp | Excel Programming | |||
Help with HLOOKUP Please | Excel Programming | |||
Rounding criteria within a nested vlookup and hlookup | Excel Worksheet Functions | |||
hlookup in VBA | Excel Programming |