![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
Exercise 11 : Create simplified Vlookup version
1. Create a UDF Vlkup( User Defined Function)
To create this Function, execute the following steps
Define Name With Below Range score :A2:C8
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(8,score,3,FALSE)