Exercise 8: Condensing HLOOKUP 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 hlkup() In Cell C2 Type

= hlkup(product,Range("produ"), 3, 0)

Syntax

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

=HLOOKUP(C25,B17:D22,3,FALSE)