Scribd
Upload
107 views6 pages

Index & Match Practice Workbook

The document shows the rates per kg of various agricultural products including wheat, oil, sugar, rice, salt, corn, oats, amaranth, barley, and bulgur at quantities of 2kg, 5kg, and 10kg. It demonstrates using Excel functions like INDEX, MATCH, and INDEX MATCH to lookup values from the table as well as comparing VLOOKUP to INDEX MATCH. The rates are listed in Indian Rupees (Rs.).

Uploaded by

nijam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
107 views6 pages

Index & Match Practice Workbook

The document shows the rates per kg of various agricultural products including wheat, oil, sugar, rice, salt, corn, oats, amaranth, barley, and bulgur at quantities of 2kg, 5kg, and 10kg. It demonstrates using Excel functions like INDEX, MATCH, and INDEX MATCH to lookup values from the table as well as comparing VLOOKUP to INDEX MATCH. The rates are listed in Indian Rupees (Rs.).

Uploaded by

nijam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

1 2 3

PRODUCT RATE 2kg 5kg 10kg


1 Wheat Rs. 22 Rs. 44 Rs. 110 Rs. 220
2 Oil Rs. 122 Rs. 244 Rs. 610 Rs. 1,220
3 Sugar Rs. 50 Rs. 100 Rs. 250 Rs. 500
4 Rice Rs. 68 Rs. 136 Rs. 340 Rs. 680
5 Salt Rs. 18 Rs. 36 Rs. 90 Rs. 180
6 Corn Rs. 42 Rs. 84 Rs. 210 Rs. 420
7 Oats Rs. 190 Rs. 380 Rs. 950 Rs. 1,900
8 Amaranth Rs. 60 Rs. 120 Rs. 300 Rs. 600
9 Barley Rs. 400 Rs. 800 Rs. 2,000 Rs. 4,000
10 Bulgur Rs. 30 Rs. 60 Rs. 150 Rs. 300

INDEX Function
Rice (Row) Rs. 680
Rice (Row + Col) Rs. 340
1 2 3
PRODUCT RATE 2kg 5kg 10kg
1 Wheat Rs. 22 Rs. 44 Rs. 110 Rs. 220
2 Oil Rs. 122 Rs. 244 Rs. 610 Rs. 1,220
3 Sugar Rs. 50 Rs. 100 Rs. 250 Rs. 500
4 Rice Rs. 68 Rs. 136 Rs. 340 Rs. 680
5 Salt Rs. 18 Rs. 36 Rs. 90 Rs. 180
6 Corn Rs. 42 Rs. 84 Rs. 210 Rs. 420
7 Oats Rs. 190 Rs. 380 Rs. 950 Rs. 1,900
8 Amaranth Rs. 60 Rs. 120 Rs. 300 Rs. 600
9 Barley Rs. 400 Rs. 800 Rs. 2,000 Rs. 4,000
10 Bulgur Rs. 30 Rs. 60 Rs. 150 Rs. 300

MATCH Function
Rice 4
1 2 3
PRODUCT RATE 2kg 5kg 10kg
1 Wheat Rs. 22 Rs. 44 Rs. 110 Rs. 220
2 Oil Rs. 122 Rs. 244 Rs. 610 Rs. 1,220
3 Sugar Rs. 50 Rs. 100 Rs. 250 Rs. 500
4 Rice Rs. 68 Rs. 136 Rs. 340 Rs. 680
5 Salt Rs. 18 Rs. 36 Rs. 90 Rs. 180
6 Corn Rs. 42 Rs. 84 Rs. 210 Rs. 420
7 Oats Rs. 190 Rs. 380 Rs. 950 Rs. 1,900
8 Amaranth Rs. 60 Rs. 120 Rs. 300 Rs. 600
9 Barley Rs. 400 Rs. 800 Rs. 2,000 Rs. 4,000
10 Bulgur Rs. 30 Rs. 60 Rs. 150 Rs. 300

INDEX + MATCH Function


[ROW] Oats 5kg 950
[ROW + COL] Barley 2kg Rs. 800
=
1 2
PRODUCT ID RATE 2kg 5kg
1 Wheat 123456 Rs. 22 Rs. 44 Rs. 110
2 Oil 123457 Rs. 122 Rs. 244 Rs. 610
3 Sugar 123458 Rs. 50 Rs. 100 Rs. 250
4 Rice 123459 Rs. 68 Rs. 136 Rs. 340
5 Salt 123460 Rs. 18 Rs. 36 Rs. 90
6 Corn 123461 Rs. 42 Rs. 84 Rs. 210
7 Oats 123462 Rs. 190 Rs. 380 Rs. 950
8 Amaranth 123463 Rs. 60 Rs. 120 Rs. 300
9 Barley 123464 Rs. 400 Rs. 800 Rs. 2,000
10 Bulgur 123465 Rs. 30 Rs. 60 Rs. 150

INDEX MATCH vs VLOOKUP


VLOOKUP 123456
IND + MAT 123465
3
10kg
Rs. 220
Rs. 1,220
Rs. 500
Rs. 680
Rs. 180
Rs. 420
Rs. 1,900
Rs. 600
Rs. 4,000
Rs. 300

You might also like