Two-dimensional lookup

Advanced formulas

Concatenate

Based on a condition

Unique distinct values

Drop-down list

Join without TEXTJOIN

Lookup & return values

Compare

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Two price lists

Records in two tables

Common records

Update recent values(2)

Missing values two cols

Update recent values

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

Combine merge

Merge tables

Merge rows - condition

Combine ranges [UDF]

Merge matching rows

Merge 2 cols w. blanks

Pattern in cell value

Overlapping time

Containing any list value

Unique distinct/condition

Count cells based on background color programmatically

Equal values per row

Count overlapping days

Sort count freq. condi.

Count overlap. days(2)

Count overlap. days(1)

Contiguous values

Comma separated vals

Count Conditionally Formatted cells

Count based on color

Count filtered table

Groups of each value

Weekday in date range

Weekday date range(2)

Cells between value

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Count groups in calendar

Uniq. dist. based dates

Count based on date

Numbers across sheets

Cells between values

Most freq/date range

Unique distinct months

Uniq. dist. 2 cols

Unique dist. values

Dates

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Find date range based on a date

Create date ranges

Weekday in date range

Calc dates in project

Weeks from ranges

Weekday date range(2)

Entries date & time rng

Overlap. date ranges

Overlap rngs - condition

Count groups in calendar

Dates from overlap rngs

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Most freq/date range

Find min/max date rng

Blank between quarters

Dupe vals sorted date

Create date range

Lookup the nearest date

Based on a date range

Machine utilization

Date based on wkday

Find numbers in sum

Numbers closest to sum

Count overlapping days

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Overlap rngs - condition

Based on date criteria

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Sorted alphabetically

Sorted A->Z

Sorted & no blanks - rng

Sort length

From a cell range

Sorted A-Z from range

Contains string in rng

Begins with criterion

Based on a date range

Based on dates

Year - month from dates

Based on date criteria

Extract filtered table

Extract & sum condition

Two conditions

Sum uniq. dist. rec.

Assign randomly unique

Sums, return unique

Sorted, no blanks - rng

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using criteria

Common values 3 lists

Label duplicate records

Dupes - date, wk, month

Dupes from rng contain

Filter dupes begins w.

Min unique number

Dupe vals sorted date

Create a list of duplicates where adjacent cell value meets a condition

Sort column - frequency

Frequency - criteria

Sort rng - frequency

Sort count freq. condi.

Sort two columns

Sort records

Sort table

Sort adj. txt horiz. (1)

Sort unique A-Z blanks

Sort cell delimiter [VBA]

Sort Excel table [VBA]

Sort based on proximity

Sort dates - criteria

Vlookup and return multiple values

5 easy ways

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup range

Vlookup rng - records

Vlook col - return rng

Search and return multiple values

Distribute values across numerical ranges

Search values and return value with highest level

Strings in any 2 cols

Strings in 2 cols each

Strings in column

Contains string - column

Filter records

Extract using criteria

Extract using criteria(2)

Extract using criteria(3)

Recs betw. this & that

Records betw. 2 dates

Date range & condition

Records in two tables

Unique records

Common records

Duplicate columns

Unique distinct records

Extract unique distinct records from two data sets

Sort based on freq.

Filter unique distinct records using criteria

Count uniq. dist. [2010]

Unique dist. rec. criteria

Records - condition(2)

Records - condition(1)

Filter unique distinct records

Count unique distinct records

Duplicate records

Extract duplicate records

Count records

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 discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]

Reverse two-way lookups

This article demonstrates a few different formulas that extract values from the table column header names and the right-most column. […]

How to use the INDEX function

Gets a value in a specific cell range based on a row and column number.

Shift Schedule

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) […]