Data anlysis using Hlookup in Excel

Data analysis using Hlookup: Generally the price of a product changes with time. This may be due increase in Raw material costs, interest costs, processing costs, salaries, etc. Sometimes governments can change their policies on the amount of VAT (Value added Tax) to be charged. How can we use Hlookup to get the correct item price from a large amount of data for a relevant date and use it in our calculations? Let's say we have the following data: