Forum Discussion
Find the column and row number in an excel spread sheet based on criteria.
Hi Good day, I am looking for a way to find the address of a cell based on a criteria. I am having specific data placed randomly in sheet 1 of a workbook in different columns and rows. (like Apple,...
A top-down approach that will return multiple matches
= LET(
address, ADDRESS(ROW(matrix), COLUMN(matrix), , 0),
matches, IF(matrix=target, address, NA()),
TOROW(matches, 3)
)