Hi all
Would anyone be able to help me with this formula?
Eg:
Sheet 1 has Column A with a list of codes form one source.
Sheet 2 has Column A with a list of codes from another source.
If sheet2 has cell A1 as: ABC123, I want A2 to search for that string in sheet 1 Column A and return a True value if it is in that Column.
I need the formula to put into Sheet 2 A2
Thanks
Bookmarks