Hi there folks!
I have a workbook that contains multiple worksheets for each month of the year that all contain a date, a house number, and other various information on shipments. These worksheets are distinguished by month and are organized by least recent to most recent. The sample is below.
I would really like to create a formula that can go into an added column C (added manually) and check to see if the number in column B is duplicated in any of the other worksheets, and return either the date (column A) or "Not Duplicated". I was thinking a VLookup but I'm not sure.
So there are two worksheets attached, the first being the original workbook with almost all the months and data, and the second one being what I desire as the outcome. In the second one, July is the month that I chose to put the column in. Any help would be much, much appreciated. I am using Excel 2003 so I am sure that will affect how to write this formula.
Thanks!
Bookmarks