If a cell in column A has a value of 1, i would like the address of another cell in that another column (for instance B) to appear in the C column.
Not the contents of cell B, but the actual cell location, such as B1, would need to appear in column C
Bookmarks