show data from sheet 2 while selecting cell value from sheet 1

[azii]

hi there
i have two data sheets,
sheet 1 for summary
sheet 2 for data
i want that if i select cell b4 value and cell c4 value, it should get data from sheet 2 with matching my two selected cell values.

Sheet 1 (the Summary Sheet ( here under crop, Farmetr Type an Tubewell i need to select these three values and in sheet 2 i need to match and get a certain cell value

Crop	Farmer Type	Tubewell
Potato	Average	Electricity
			Title	Amount
			Total Expense	165,533.32
			Total Income	278,731.43
			Net Profit	113,198.11
			VCR	73.71

Sheet 2

Crop	Farmer Type	Amount Rs
Maize	Progressive	156,624
Maize	Progressive	278,731
Maize	Progressive	122,107
Maize	Progressive	0.78
Potato	Progressive	165,533
Potato	Progressive	278,731
Potato	Progressive	113,198
Potato	Progressive	0.68
Rice	Progressive	182,241
Rice	Progressive	278,731
Rice	Progressive	96,491
Rice	Progressive	0.53
Rice	Progressive	182,241
Rice	Progressive	278,731
Rice	Progressive	96,491
Rice	Progressive	0.53
Maize	Average	156,624
Maize	Average	278,731
Maize	Average	122,107
Maize	Average	0.78
Potato	Average	165,533
Potato	Average	278,731
Potato	Average	113,198
Potato	Average	0.68
Rice	Average	182,241
Rice	Average	278,731
Rice	Average	96,491
Rice	Average	0.53
Rice	Average	182,241
Rice	Average	278,731
Rice	Average	96,491
Rice	Average	0.53
Maize	PE/Tractor	156,624
Maize	PE/Tractor	278,731
Maize	PE/Tractor	122,107
Maize	PE/Tractor	0.78
Potato	PE/Tractor	165,533
Potato	PE/Tractor	278,731
Potato	PE/Tractor	113,198
Potato	PE/Tractor	0.68
Rice	PE/Tractor	182,241
Rice	PE/Tractor	278,731
Rice	PE/Tractor	96,491
Rice	PE/Tractor	0.53
Rice	PE/Tractor	182,241
Rice	PE/Tractor	278,731
Rice	PE/Tractor	96,491
Rice	PE/Tractor	0.53
Maize	Electricity	156,624
Maize	Electricity	278,731
Maize	Electricity	122,107
Maize	Electricity	0.78
Potato	Electricity	165,533
Potato	Electricity	278,731
Potato	Electricity	113,198
Potato	Electricity	0.68
Rice	Electricity	182,241
Rice	Electricity	278,731
Rice	Electricity	96,491
Rice	Electricity	0.53
Rice	Electricity	182,241
Rice	Electricity	278,731
Rice	Electricity	96,491
Rice	Electricity	0.53

Please help resolve the issue

 

[SanjayGMusafir]

Sorry for late response, I was out for some work. I think is was you want - I have marked as solution.

Check this and revert -

Book1
	A	B	C	D	E	F	G	H	I	J	K
1									Crop	Farmer Type	Amount Rs
2		Crop	Farmer Type	Tubewell					Maize	Progressive	1,56,624.29
3		Potato	Average	Electricity					Maize	Progressive	2,78,731.43
4					Title	Amount	Solution		Maize	Progressive	1,22,107.14
5					Total Expense	FALSE	1,65,533.32		Maize	Progressive	0.78
6					Total Income	FALSE	2,78,731.43		Potato	Progressive	1,65,533.32
7					Net Profit	FALSE	1,13,198.11		Potato	Progressive	2,78,731.43
8					VCR	FALSE	0.68		Potato	Progressive	1,13,198.11
9									Potato	Progressive	0.68
10									Rice	Progressive	1,82,240.78
11									Rice	Progressive	2,78,731.43
12									Rice	Progressive	96,490.65
13									Rice	Progressive	0.53
14									Maize	Average	1,56,624.29
15									Maize	Average	2,78,731.43
16									Maize	Average	1,22,107.14
17									Maize	Average	0.78
18									Potato	Average	1,65,533.32
19									Potato	Average	2,78,731.43
20									Potato	Average	1,13,198.11
21									Potato	Average	0.68
22									Rice	Average	1,82,240.78
23									Rice	Average	2,78,731.43
24									Rice	Average	96,490.65
25									Rice	Average	0.53
26									Maize	PE/Tractor	1,56,624.29
27									Maize	PE/Tractor	2,78,731.43
28									Maize	PE/Tractor	1,22,107.14
29									Maize	PE/Tractor	0.78
30									Potato	PE/Tractor	1,65,533.32
31									Potato	PE/Tractor	2,78,731.43
32									Potato	PE/Tractor	1,13,198.11
33									Potato	PE/Tractor	0.68
34									Rice	PE/Tractor	1,82,240.78
35									Rice	PE/Tractor	2,78,731.43
36									Rice	PE/Tractor	96,490.65
37									Rice	PE/Tractor	0.53
38									Maize	Electricity	1,56,624.29
39									Maize	Electricity	2,78,731.43
40									Maize	Electricity	1,22,107.14
41									Maize	Electricity	0.78
42									Potato	Electricity	1,65,533.32
43									Potato	Electricity	2,78,731.43
44									Potato	Electricity	1,13,198.11
45									Potato	Electricity	0.68
46									Rice	Electricity	1,82,240.78
47									Rice	Electricity	2,78,731.43
48									Rice	Electricity	96,490.65
49									Rice	Electricity	0.53
Sheet1

Cell Formulas
Range	Formula
G5:G8	G5	=FILTER($K:$K,($I:$I=$B$3)*($J:$J=$D$3))
F5:F6	F5	=IF($D$5="Maize",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]Sheet2'!I3,IF($D$5="Potato",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-E-NP'!I74,IF($D$5="Rice",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-NP'!I72,IF($D$5="Citrus (Kinnow)",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-DAP'!I72:I72))))
F7	F7	=IF($D$5="Maize",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-E-DAP'!I76,IF($D$5="Potato",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-E-NP'!I76,IF($D$5="Rice",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-NP'!I74,IF($D$5="Citrus (Kinnow)",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-DAP'!I74:I74))))
F8	F8	=IF($D$5="Maize",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-E-DAP'!I77,IF($D$5="Potato",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-E-NP'!I77,IF($D$5="Rice",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-NP'!I75,IF($D$5="Citrus (Kinnow)",'/Users/SGM/Library/Containers/com.microsoft.Excel/Data/Documents/C:\Users\asif.zamir\Desktop\[VCR Test.xls]M-P-O-O-PE-DAP'!I76))))
Dynamic array formulas.