lookup multiple criteria

[Lazaeb]

Need Help,

I have to lookup several values in a table and need return in one cell,

For example:
Search Array

Search Value 1	Search Value 2	Result
2000014	10004375	1072.32
2000014	10004380	536.16
2000023	10004375	3753.12
2000023	10004380	1876.56

<tbody>
</tbody>

Now I need

Value 1	Value 2	Value 3	Value 4	Value 5	Need Result Here
2000014		10004666	10004558	10004372
2000014		10004667	10004559	10004373
2000014		10004668	10004560	10004374
2000014			10004675	10004375
2000014			10004676	10004380
2000014		10004669	10004561	10004378
2000014		10004670	10004562	10004379
2000014		10004671	10004563	10004383
2000014		10004672	10004564	10004384
2000014	10004513	10004664	10004565	10004386
2000014		10004673	10004566	10004387
2000014		10004665	10004567	10004389
2000014		10004674	10004568	10004390
2000014			10004596	10004414
2000014				10004415
2000014				10004376
2000014				10004381

<tbody>
</tbody>

 

[Eric W]

Not sure exactly what you want, but maybe:

	A	B	C	D	E	F	G	H	I	J	K
1	Search Value 1	Search Value 2	Result		Value 1	Value 2	Value 3	Value 4	Value 5	Need Result Here
2	2000014	10004375	1072.32		2000014		10004666	10004558	10004372	0
3	2000014	10004380	536.16		2000014		10004667	10004559	10004373	0
4	2000023	10004375	3753.12		2000014		10004668	10004560	10004374	0
5	2000023	10004380	1876.56		2000014			10004675	10004375	1072.32
6					2000014			10004676	10004380	536.16
7					2000014		10004669	10004561	10004378	0
8					2000014		10004670	10004562	10004379	0
9					2000014		10004671	10004563	10004383	0
10					2000014		10004672	10004564	10004384	0
11					2000014	10004513	10004664	10004565	10004386	0
12					2000014		10004673	10004566	10004387	0
13					2000014		10004665	10004567	10004389	0
14					2000014		10004674	10004568	10004390	0
15					2000014			10004596	10004414	0
16					2000014				10004415	0
17					2000014				10004376	0
18					2000014				10004381	0
19

<tbody>
</tbody>

Sheet2​

Array Formulas Cell Formula J2 {=MAX(SUMIFS($C$2:$C$10,$A$2:$A$10,E2,$B$2:$B$10,$F2:$I2))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>