Multiple lookup criteria

Clive Southon

New Member
Joined
Apr 25, 2013
Messages
8
Hello there.

I need help with a lookup matter.
My efforts to use INDEX and MATCH have not worked.
A system generated report is received is in columns and looks like this:

Ticket ID Type Measure Oct 2019 Overall Result
7004114394 Amount Finalized H 1.00 1.00
7004114394 Average Author Action Time H
0.00 0.00
7004114394 Average Waiting Time H
0.48 0.48
7004114394 Average Process Time H
2058.60 2058.60
7004114394 Average End-to-End Duration H
2059.07 2059.07
7004114394 Average Lifecycle Time H
2059.07 2059.07
7004172682
Amount Finalized H
1.00 1.00
7004172682
Average Author Action Time H
0.00 0.00
7004172682
Average Waiting Time H
3.75 3.75
7004172682
Average Process Time H
698.07 698.07
7004172682
Average End-to-End Duration H
885.40 885.40
7004172682
Average Lifecycle Time H
1253.37 1253.37

I need to put each Ticket Number, with the different headings in a row so each row is unique.

NOTE: I have only used TWO of the Ticket numbers - there could be a hundred.

Thanks in advance.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Your post is virtually impossible to distinguish columns as presented. Here is information from the forum rules on how to post:

Posting Aids


N.B.
- With any of the Add-Ins with recent versions of Windows, you may need to "unblock" the file. In Windows Explorer, find the file, right-click, Properties, General tab, tick the 'Unblock' box down near the bottom.
- If you end up with two small squares in your Reply window with any of the HTML makers, close any open Windows Explorer windows and try again.
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,193
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top