How do I write a formula to compute tax rates based on income?
Given a product ID, how can I look up the product’s price?
Suppose that a product’s price changes over time. I know the date the product was sold. How can I write a formula to compute the product’s price?
Lookup functions enable you to "look up" values from worksheet ranges. Excel allows you to perform both vertical lookups (using VLOOKUP functions) and horizontal lookups (using HLOOKUP functions). In a vertical lookup, the lookup operation starts in the first column of a worksheet range. In a horizontal lookup, the operation starts in the first row of a worksheet range. Because the great majority of formulas using lookup functions ...