default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
I am not even sure if this is possible or not, but here it goes.
I have two spreadsheets.
Each spreadsheet lists a bunch of parts and part numbers.
Spreadsheet A is the database of existing parts in the system.
Spreadsheet B is a list of parts from a batch.
In Spreadsheet B I want to be able to set up a function that will check whether or not a Spreadsheet B part is already listed in the Spreadsheet A database or not, using the Part Number as a reference. (Just returning a True or False value is sufficient).
Like so:
Spreadsheet A - The Existing Database ("Database.xlsm")
<tbody>
</tbody>
Spreadsheet B - The Batch of Parts ("Batch.xlsx")
<tbody>
</tbody>
Hope this makes sense
Thanks in advance for your help
I have two spreadsheets.
Each spreadsheet lists a bunch of parts and part numbers.
Spreadsheet A is the database of existing parts in the system.
Spreadsheet B is a list of parts from a batch.
In Spreadsheet B I want to be able to set up a function that will check whether or not a Spreadsheet B part is already listed in the Spreadsheet A database or not, using the Part Number as a reference. (Just returning a True or False value is sufficient).
Like so:
Spreadsheet A - The Existing Database ("Database.xlsm")
A | B | |
1 | Part Name | Part Number |
2 | Wrench | 00123ABC111B |
3 | Screw | 0022446688Z1 |
4 | Curvy Metal Thing | BH5556664AY5 |
5 | Thing 2PA | 2PA1114-35677 |
6 | 4 Inch Cord | 424242AAAB-401C |
7 |
<tbody>
</tbody>
Spreadsheet B - The Batch of Parts ("Batch.xlsx")
A | B | C | |
1 | Part Name | Part Number | Part Number already in Database? |
2 | Black Wire | 9544-HTXC44 | FALSE |
3 | Thing 2PB | 2PB1114-35677 | FALSE |
4 | 4 Inch Cord | 424242AAAB-401C | TRUE |
5 | 5 Inch Cord | 424242AAAB-501C | FALSE |
6 | Wrench | 00123ABC111C | FALSE |
7 | Wrench | 00123ABC111B | TRUE |
<tbody>
</tbody>
Hope this makes sense
Thanks in advance for your help