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