The coordinates are supplied from row 4 and column B, as seen in the worksheet.
This makes it easy to see at a glance where matching values are located.
These values are arbitrary and can be customized as desired.
For FALSE results, IF uses theNA functionto return a #N/A error.
These correspond to cells in B5:L16 that contain the same value as N5.
The coordinates in C4:L4 and B5:B16 can be customized as desired.
The idea is that you might customize these values as needed to support your particular use case.
However, you might also want to return Excel native cell addresses.
TEXTJOIN alternative
If you only want a list of coordinates as a text string (i.e.
I’m not sure why this is.
By default, TOCOL will scan values by row, but TOCOL can also scan values by column.
More than one condition can be tested by nesting IF functions.
For example, =ADDRESS(1,1) returns $A$1.
ROW Function
The Excel ROW function returns the row number for a reference.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
COLUMN Function
The Excel COLUMN function returns the column number for a reference.
For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.
When no reference is provided, COLUMN returns the column number of the cell which contains the formula.
