Explanation
This is a basic example of VLOOKUP in “exact match” mode.
(Read why this is necessaryhere).
If no match is found, VLOOKUP will return the #N/A error.
Lookup up cost for product or service
If you have a list of products or services (or related options), with associated costs, you can use VLOOKUP to find and retrieve the cost for a specific option. In the example shown, the formula in cell F6 is: =VLOOKUP(E6,B5:C7,2,FALSE) This formula uses the value of cell E6 to lookup and retrieve the right cost in the range B5:C7.
