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
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
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.