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 11 : Create simplified Vlookup version
1. Create a UDF Vlkup( 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:
Define Name With Below Range score :A2:C8
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(8,score,3,FALSE)