Hi all,
I need a formula to return a True / False value from searching a cell value in a range of data. As an example:
Cell Ref: 12345
Data Range: A1:Z500
Can a formula return a 'True' value if that number - 12345 - is located somewhere in the data range?
Thank you,
Lee.
Bookmarks