Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview

Exercise 11 : Create simplified Vlookup version

1. Create a UDF Vlkup( 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:

Define Name With Below Range score :A2:C8

Syntax

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

=VLOOKUP(8,score,3,FALSE)