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.
Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]
This article demonstrates a few different formulas that extract values from the table column header names and the right-most column. […]
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) […]