Morning,
Which is the best formula to identify where data has come from, for example i have some data in cell B2 but i need to identify where that data is on another sheet.
Data in B2 is on a sheet call Current Month's Template and the source data is on a sheet called PDQ
I have tried the following;
=row(Current Month's template!B2,PDQ!A:Z,1,0)
This doesn't seem to work
Any ideas
Bookmarks