Scribd
Upload
10 views2 pages

MATCH Formula Practice Exercises

The document explains the MATCH function, which identifies the position of a value in a range. It provides example data of product sales and includes practice questions to find specific positions in the list. The answers to the practice questions are also included, demonstrating the use of the MATCH function.

Uploaded by

aakash182009
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
10 views2 pages

MATCH Formula Practice Exercises

The document explains the MATCH function, which identifies the position of a value in a range. It provides example data of product sales and includes practice questions to find specific positions in the list. The answers to the practice questions are also included, demonstrating the use of the MATCH function.

Uploaded by

aakash182009
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

MATCH Formula Practice

Explanatio The MATCH function returns the position of a value in a range. It can be used to find the row or column number of

Example Data:
Product Sales
Apple 500
Banana 300
Mango 700
Orange 400
Grapes 600

Practice QuFind the position of 'Mango' in the product list.

Answer (Fo 3

Practice QuFind the position of the first product with sales equal to 400.

Answer (Fo 4
the row or column number of a specific item.

You might also like