Two-dimensional lookup
Excel » Two-dimensional lookup »
Get date ranges from a schedule
The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]
Two-dimensional lookup using two tables
The following formula performs a two-way lookup in two different tables.
Use VLOOKUP to calculate discount percentages
Have you ever tried to build a formula to calculate discounts depending on price? The VLOOKUP function is much easier to […]
The table of contents below lets you quickly navigate to the formula you are looking for. The excel 2016 formula […]
Gets a value in a specific cell range based on a row and column number.
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]
How to perform a two-dimensional lookup
Question: How would I go about looking up data in a cross-reference table. I have the header row (i.e. 24) […]
Welcome! I am 