Q: Multiple row-multiple column table lookup

MarinM

New Member
Joined
Dec 14, 2008
Messages
46
From a table (Sheet1) I want to fetch data based on two columns and three rows using formulas or VBA that checks until the first empty row or first empty column. Criteria is in rows 1:3 and columns A:B. There is always only one combination for certain parameters, e.g. Jack, 01.01.96-31.12.96, 1 (column A) and 6 (Column B) appears only once and at intersection of it is number 2.
Excel Workbook
ABCDEFGHIJKLM
1ObjectGlennJackJohnRossMelindaRalphEdMelindaJohnJackJack
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


What do I have to do in order to get output in column C on Sheet2 based on cells B1:B3 Sheet2 and A5:B24 on Sheet2?
For Sheet1 and given input on Sheet2, output in column C Sheet2 should look like in the picture:
Excel Workbook
ABC
1PersonJack
2From01.01.96.
3To31.12.96.
4Column1ToValue
5SUM 8SUM4
6SUM 9SUM4
7111
8121
9131
10142
11151
12162
13171
14182
15191
161101
171110
181120
191131
201141
211152
221162
231172
241180
Sheet2
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,224,586
Messages
6,179,729
Members
452,939
Latest member
WCrawford

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