Find based on multiple criteria

MarinM

New Member
Joined
Dec 14, 2008
Messages
46
Dear All,

I have one big table on Sheet1. I would like to pull data from there to Sheet2!D5:D27 based on multiple criteria in Sheet2!B1:B3;B5:B27 (Person, From and To have to be exact match; although each of them can be repeated multiple times, their combination is repeated only once). Which formula I have to copy/paste down in cells D5:D27 to get the results as shown in this example?
Excel Workbook
ABCDEFGHIJKLM
1PersonGlennJackJohnRossMelindaRalphEdMelindaJohnJackJack
2From01.02.95.01.02.95.01.02.95.01.02.95.01.02.95.01.02.95.02.04.97.01.03.95.01.01.96.01.01.96.01.01.97.
3To31.12.95.31.12.95.31.12.95.31.12.95.31.12.95.31.12.95.18.09.98.31.11.9531.12.96.31.12.96.30.06.97.
4SUM 1SUM60368144451082324917885
5SUM 2SUM49226932137544880311154017
6SUM 3SUM237682642316331404151056
7SUM 4SUM6618882157057146104911413
8SUM 5SUM3994924454134754883219
9SUM 6SUM87689125303345819910
10SUM 7SUM60738976323995241317422
11SUM 8SUM355123324131212512436421
12SUM 9SUM78115423261487162141
131120131117451011
14121155131221010
15131143194181011
161421531116280021
171571821113230011
181622163381340120
Sheet1
Excel Workbook
ABCD
1PersonJack
2From1.1.1997
3To30.6.1997
4GroupConcatenateValue
53SUM 36
64SUM 413
75SUM 519
86SUM 610
97SUM 722
101SUM 15
112SUM 217
123SUM 36
134SUM 413
145SUM 519
156SUM 610
167SUM 722
171SUM 15
182SUM 217
193SUM 36
204SUM 413
215SUM 519
226SUM 610
237SUM 722
241SUM 15
252SUM 217
269SUM 91
279SUM 91
Sheet2


Thank you in advance
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,224,565
Messages
6,179,549
Members
452,927
Latest member
rows and columns

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