Thread: Checking for exsitence of values in a different worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dirk_Bob Dirk_Bob is offline
external usenet poster
  
Posts: 4
Default Checking for exsitence of values in a different worksheet
I have two work sheets defined, Sheet1 column A contains a list of part
numbers.
Sheet 2 column A contains a list of part numbers.

I would like to create a formula in Sheet1 column B that displays "True" if
the part number exists in Sheet 2 column a.

I tried Vlookup, but seem to be having issues.
--
Dirk
Reply With QuoteReply With Quote