Loop Query

[Mayur Prabhu]

Please help me to automate my sheet.
Problem Statement attached.

 

[hagia_sofia]

Since there are no names of your sheets, adjust the ranges according to your data (C9:C11, A9:A11, B9:B11 represent your table 2 data):

=IFERROR(INDEX($C$9:$C$11,MATCH(1,($A$9:$A$11=$A2)*($B$9:$B$11=B$1),0)),"")

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Loop Query

Problem Statement is attached herewith. Please help me automate my sheet.

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Alex Blakenburg]

Welcome to the Forum.
If you are using Excel 2016, I suspect the above will require you to enter it as an array formula.
Here is a non-array option.

20240627 2D Lookup Mayur Prabhu.xlsx
	A	B	C	D	E	F
1		12	23	34	45	56
2	Job 1	Tom - 0
3	Job 2			Sam - 1
4	Job 3					Ron - 1
5	Job 4
6	Job 5
Sheet1

Cell Formulas
Range	Formula
B2:F6	B2	=IFERROR(LOOKUP(2,1/((Sheet2!$A$1:$A$3=$A2)*(Sheet2!$B$1:$B$3=B$1)),Sheet2!$C$1:$C$3),"")

Sheet2 data used:

20240627 2D Lookup Mayur Prabhu.xlsx
	A	B	C
1	Job 1	12	Tom - 0
2	Job 2	34	Sam - 1
3	Job 3	56	Ron - 1
Sheet2

 

[Mayur Prabhu]

Welcome to the Forum.
If you are using Excel 2016, I suspect the above will require you to enter it as an array formula.
Here is a non-array option.

20240627 2D Lookup Mayur Prabhu.xlsx
	A	B	C	D	E	F
1		12	23	34	45	56
2	Job 1	Tom - 0
3	Job 2			Sam - 1
4	Job 3					Ron - 1
5	Job 4
6	Job 5
Sheet1

Cell Formulas
Range	Formula
B2:F6	B2	=IFERROR(LOOKUP(2,1/((Sheet2!$A$1:$A$3=$A2)*(Sheet2!$B$1:$B$3=B$1)),Sheet2!$C$1:$C$3),"")

Sheet2 data used:

20240627 2D Lookup Mayur Prabhu.xlsx
	A	B	C
1	Job 1	12	Tom - 0
2	Job 2	34	Sam - 1
3	Job 3	56	Ron - 1
Sheet2

Thank You so much.....This was very helpful.....It worked...Finally i can sleep peacefully..

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.