Functions

VLOOKUP Function Excel Tutorial – Find Things In A Table

COUNTIF Excel Tutorial – Count Cells That Meet A Condition In A Range

IF Function Excel Tutorial – Test Whether A Condition Holds Using Simple and Nested IF

MATCH Function Excel Tutorial – Find Position Of A Cell In A Range

INDIRECT Function Excel Tutorial – Return A Cell Value Specified By A Text String

ADDRESS Function Excel Tutorial – Return The Address Of A Cell For A Given ROW And COLUMN Number

Use XLOOKUP Instead Of VLOOKUP To Find Things In A Table | XLOOKUP Function Excel Tutorial

CONCATENATE VS CONCAT VS TEXTJOIN – Join Text From Different Cells Together In Excel