LinkBack URL
About LinkBacks
This assumes that the first list is in column A and the second list is in column B of the same sheet. This formula goes in any other column on the same sheet.
Formula:
=NOT(ISERROR(MATCH(B2,A:A,0)))
will give TRUE for found and FALSE for not found.
This assumes that the first list is in column A and the second list is in column B of the same sheet. This formula goes in any other column on the same sheet.
Formula:=NOT(ISERROR(MATCH(B2,A:A,0)))
will give TRUE for found and FALSE for not found.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks