Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview
PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.
Download the book in PDF, ePub, Kindle for a complete version.
Exercise 9. Simplifying excel sheet Match function
1. Create a UDF (User Defined Function)
To create this Function, execute the following steps
- Open Excel VBA (Altl + F11)
- Insert a New Module
- In the Project Explorer, double click on the Module
- 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)