1 | A | B | C | D | E | F | |
|---|---|---|---|---|---|---|---|
2 | 1 | Category | Weight | Price | Quantity | ||
3 | 2 | Apple | Plant | 150 | 20 | 1 | |
4 | 3 | Banana | Plant | 125 | 15 | 2 | |
5 | 4 | Chicken | Animal | 2250 | 300 | 4 | |
6 | 5 | Orange | Plant | 200 | 30 | 4 | |
7 | 6 | Pig | Animal | 80000 | 1000 | 5 | |
8 | 7 | ||||||
9 | 8 | ||||||
10 | Formula | Result | |||||
11 | =MATCH("Chicken",A2:A6,1) | 3 | |||||
12 | =MATCH(2,E2:E6) | 2 | |||||
13 | =MATCH(3.9,E2:E6) | 2 | |||||
14 | =MATCH(4,E2:E6) | 4 | |||||
15 | =MATCH(30,D:D,0) | 5 |