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
Sheet 2
Please help resolve the issue
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