Index data horizontally and return data vertically

A

Aton999

New Member
Joined
Dec 3, 2015
Messages
39
Hi,

I have a set of data (table below) assuming data start from A1. Basically I am looking to match multiple criteria (Team1=Team1) & (Low = Low) & (Full Time = Full Time) and when matched, return values vertically (Skip empty rows).
[TABLE="width: 960"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1024"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="width: 64"]C[/TD]
[TD="width: 64"]D[/TD]
[TD="width: 64"]E[/TD]
[TD="width: 64"]F[/TD]
[TD="width: 64"]G[/TD]
[TD="width: 64"]H[/TD]
[TD="width: 64"]I[/TD]
[TD="width: 64"]J[/TD]
[TD="width: 64"]K[/TD]
[TD="width: 64"]L[/TD]
[TD="width: 64"]M[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]O[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]
[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Team2[/TD]
[TD="class: xl67"]Team2[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl68"]Team[/TD]
[TD="class: xl68"]Job Type[/TD]
[TD="class: xl68"]Task[/TD]
[TD="class: xl68"]Criticality[/TD]
[TD="class: xl69"]Tom[/TD]
[TD="class: xl69"]John[/TD]
[TD="class: xl69"]kel[/TD]
[TD="class: xl69"]mat[/TD]
[TD="class: xl69"]Sue[/TD]
[TD="class: xl69"]jan[/TD]
[TD="class: xl69"]hay[/TD]
[TD="class: xl69"]matt[/TD]
[TD="class: xl69"]moon[/TD]
[TD="class: xl69"]Am1[/TD]
[TD="class: xl69"]hel1[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl67"]Team1
[/TD]
[TD="class: xl67"]Full Time
[/TD]
[TD="class: xl67"]Task1
[/TD]
[TD="class: xl67"]Low
[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]22[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD="class: xl67, align: right"]26[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]26[/TD]
[TD="class: xl67, align: right"]78[/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task2[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]84[/TD]
[TD="class: xl67, align: right"]61[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]88[/TD]
[TD="class: xl67, align: right"]23[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Part Time[/TD]
[TD="class: xl67"]Task3[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]67[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]61[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="class: xl67"]Team2[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task4[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]43[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]75[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl65"]7[/TD]
[TD="class: xl67"]Team2[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task5[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]95[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]26[/TD]
[TD="class: xl67, align: right"]37[/TD]
[/TR]
[TR]
[TD="class: xl65"]8[/TD]
[TD="class: xl67"]Team2[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task6[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]37[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]32[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]79[/TD]
[/TR]
[TR]
[TD="class: xl65"]9[/TD]
[TD="class: xl67"]Team3[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task6[/TD]
[TD="class: xl67"]Mid[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]30[/TD]
[/TR]
[TR]
[TD="class: xl65"]10[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Part Time[/TD]
[TD="class: xl67"]Task7[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]52[/TD]
[/TR]
[TR]
[TD="class: xl65"]11[/TD]
[TD="class: xl67"]Team3[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task8[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]61[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]46[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]61[/TD]
[/TR]
[TR]
[TD="class: xl65"]12[/TD]
[TD="class: xl67"]Team3[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task9[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]23[/TD]
[TD="class: xl67, align: right"]88[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]23[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]49[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]47[/TD]
[/TR]
[TR]
[TD="class: xl65"]13[/TD]
[TD="class: xl67"]Team3[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task10[/TD]
[TD="class: xl67"]Mid[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]45[/TD]
[/TR]
[TR]
[TD="class: xl65"]14[/TD]
[TD="class: xl67"]Team1[/TD]
[TD="class: xl67"]Part Time[/TD]
[TD="class: xl67"]Task11[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]45[/TD]
[/TR]
[TR]
[TD="class: xl65"]15[/TD]
[TD="class: xl67"]Team3[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task12[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl65"]16[/TD]
[TD="class: xl67"]Team2[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task13[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]57[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]46[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]71[/TD]
[/TR]
[TR]
[TD="class: xl65"]17[/TD]
[TD="class: xl67"]Team4[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task14
[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]26[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]41[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]57[/TD]
[/TR]
[TR]
[TD="class: xl65"]18[/TD]
[TD="class: xl67"]Team4[/TD]
[TD="class: xl67"]Part Time[/TD]
[TD="class: xl67"]Task15[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]67[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]57[/TD]
[TD="class: xl67, align: right"]70[/TD]
[/TR]
[TR]
[TD="class: xl65"]19[/TD]
[TD="class: xl67"]Team4[/TD]
[TD="class: xl67"]Hourly[/TD]
[TD="class: xl67"]Task16[/TD]
[TD="class: xl67"]High[/TD]
[TD="class: xl67, align: right"]43[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]40[/TD]
[/TR]
[TR]
[TD="class: xl65"]20[/TD]
[TD="class: xl67"]Team4[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task17[/TD]
[TD="class: xl67"]Mid[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]58[/TD]
[TD="class: xl67, align: right"]80[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]23[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]96[/TD]
[/TR]
[TR]
[TD="class: xl65"]21[/TD]
[TD="class: xl67"]Team4[/TD]
[TD="class: xl67"]Full Time[/TD]
[TD="class: xl67"]Task18[/TD]
[TD="class: xl67"]Low[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]92[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]46[/TD]
[TD="class: xl67, align: right"]94[/TD]
[TD="class: xl67, align: right"]23[/TD]
[TD="class: xl67, align: right"]76[/TD]
[/TR]
</tbody>[/TABLE]


Attached is link of sample data

Thank you in advanced
Aton
 
Last edited:
Sort by date Sort by votes
Aton999,

When I attempted to download your workbook, I received the following message:

Book1.xlsx is unsafe to download and was blocked by SmartScreen Filter.


You can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com
 
Upvote 0
Aton999,

I received the same message with the new link.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Solved
populate data based on multiple criteria
Replies
7
Views
378
Cubist
Cubist
I
  • Solved
Evaluate data for any price changes
2 3
Replies
23
Views
955
ItalianPlatinum
I
K
  • Question Question
conditional formatting question
Replies
2
Views
691
kerm007
K
F
  • Solved
Return maximum whole number from column of data
2
Replies
10
Views
237
Frog1
F
Z
  • Question Question
Xlookup with multiple conditions
Replies
5
Views
284
Cubist
Cubist

Share this page

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