List Search Between Workbooks

[default_name]

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")

	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

 

[Fluff]

How about
=ISNUMBER(MATCH(B2,'[Database.xlsm]Sheet1'!$B$2:$B$6,0))
Change part in red to match the database sheet name

 

[default_name]

You, Fluff, are amazing!
Worked perfectly!
Thanks again for your fluffy expertise!!

 

[Fluff]

You're welcome & thanks for the feedback