Hey.
Wondering if there is a way to search a column for a certain value and select or make that cell the active cell.
I know the LOOKUP function works for this but whenever I use it, it outputs in the selected cell the value it was searching for.
Thanks in advance.