Look up a cell address using a Criteria
The ADDRESS function is one of the least known functions in Excel.
But, It is powerful in getting cell addresses.
=ADDRESS(
MAX((Sales[Customer]=G2)*ROW(Sales[Customer])),
COLUMN(Sales[Customer]),4)
#exceltips #excel #exceltricks #cheatsheets
