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")
[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Part Name
[/TD]
[TD]Part Number
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Wrench
[/TD]
[TD]00123ABC111B
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Screw
[/TD]
[TD]0022446688Z1
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Curvy Metal Thing
[/TD]
[TD]BH5556664AY5
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Thing 2PA
[/TD]
[TD]2PA1114-35677
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]4 Inch Cord
[/TD]
[TD]424242AAAB-401C
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Spreadsheet B - The Batch of Parts ("Batch.xlsx")
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Part Name
[/TD]
[TD]Part Number
[/TD]
[TD]Part Number already in Database?
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Black Wire
[/TD]
[TD]9544-HTXC44
[/TD]
[TD]FALSE
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Thing 2PB
[/TD]
[TD]2PB1114-35677
[/TD]
[TD]FALSE
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]4 Inch Cord
[/TD]
[TD]424242AAAB-401C
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]5 Inch Cord
[/TD]
[TD]424242AAAB-501C
[/TD]
[TD]FALSE
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Wrench
[/TD]
[TD]00123ABC111C
[/TD]
[TD]FALSE
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Wrench
[/TD]
[TD]00123ABC111B
[/TD]
[TD]TRUE
[/TD]
[/TR]
</tbody>[/TABLE]

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