Exercise 9. Simplifying excel sheet Match function

1. Create a UDF (User Defined Function)

To create this Function, execute the following steps

1. Open Excel VBA (Altl + F11)
2. Insert a New Module
3. In the Project Explorer, double click on the Module
4. Add the following code line:

This Code lines will create function Matched ()

In Cell E2 Type

= Matched (product, Range("stk"), 0)

Syntax

2. Use Excel Formulas (XOR)

MATCH(lookup_value, lookup_array, [match_type])

=MATCH(E17,$C$17:$C$22,0)