dragonmouse
Board Regular
- Joined
- May 14, 2008
- Messages
- 129
- Office Version
- 2016
- Platform
- Windows
I have two worksheets: Both sheets have serials:
Sheet 1 Column B has serials from B2:B500
Sheet 2 Column E has serials from B2:4000
In column F Sheet 2. I want to compare all the serials on both sheets and IF it's a "match" I want it to return "ACTIVE" otherwise "NON-ACTIVE".
My essesence is I have a few thousand widgets we've worked. Some of these widgets are no longer in service. I need to compare between the two databases to investigate if those in service are up to date and those out of service have been destroyed Thank you in advance.
Sheet 1 Column B has serials from B2:B500
Sheet 2 Column E has serials from B2:4000
In column F Sheet 2. I want to compare all the serials on both sheets and IF it's a "match" I want it to return "ACTIVE" otherwise "NON-ACTIVE".
My essesence is I have a few thousand widgets we've worked. Some of these widgets are no longer in service. I need to compare between the two databases to investigate if those in service are up to date and those out of service have been destroyed Thank you in advance.