This will return True if the value in A1 is found in column A of sheet2:
=isnumber(match(a1,sheet2!a:a,0))

Or you could use:

=if(isnumber(match(a1,sheet2!a:a,0)),"Webstore User","not webstore user")





lbeemer wrote:

I am wanting to take a customer list and have it return a true or false value
if the number is found on another list.

Specifics- I have a master spreadsheet of all my customers sorted by their
customer number.

I have another spreadsheet that lists only those customers that have made
purchases online.

I want my master customer list to say "Webstore User" if their customer
number is found on my list of webstore users.

I feel like this would be some combination of a lookup and an if then
statement, but can not figure out how to do it.

Thanks for any help!!

--

Dave Peterson