

To create this Function, execute the following steps
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)