Is XLOOKUP TRUE the best option for this?

[AliGeeJay]

I am trying to use XLOOKUP with TRUE to look for the data in Column B (Serial Number) in the table below (Report 1) against the data in Column C (Serial Number) in Report 2. If the serial number is found then enter TRUE in Column C in Report 1 or FALSE if not found.

If XLOOKUP with TRUE is the best option, could anyone help with this please as I have been trying to solve this for a few days and cannot get this to work as needed.

If this is not the best option, again can anyone offer a better solution for me.

Report 1

Test Formula.xlsx
	A	B	C	D
1	Asset tag	Serial number	Serial Number Found?	Model number
2	L00102	10DFSL3	TRUE	Latitude 5330
3	L00009	11DFSL3	FALSE	Latitude 5330
4	L00039	12DFSL3	TRUE	Latitude 5330
5	L00328	148FSL3	TRUE	Latitude 5330
6	D00063	14WCQ04	TRUE	OptiPlex 7010
7	L00165	158FSL3	TRUE	Latitude 5330
8	D00075	15WCQ04	TRUE	OptiPlex 7010
9	L00331	168FSL3	TRUE	Latitude 5330
10	L00589	16CKHR3	TRUE	Precision 7770
Report 1

Report 2

Test Formula.xlsx
	A	B	C
1	Model	Manufacturer	Serial number
2	Precision 7770	Dell Inc.	16CKHR3
3	Latitude 5330	Dell Inc.	168FSL3
4	OptiPlex SFF 7010	Dell Inc.	15WCQ04
5	Latitude 5330	Dell Inc.	158FSL3
6	OptiPlex SFF 7010	Dell Inc.	14WCQ04
7	Latitude 5330	Dell Inc.	148FSL3
8	Latitude 5330	Dell Inc.	12DFSL3
9	Latitude 5330	Dell Inc.	11DFSL4
10	Latitude 5330	Dell Inc.	10DFSL3
Report 2

 

[Alex Blakenburg]

How about just:

=ISNUMBER(MATCH(B2,Report2!$C$2:$C$10,0))

 

[FormR]

Hi, you could try:

=ISNUMBER(MATCH(B2,'Report 2'!C:C,0))

 

[AliGeeJay]

@Alex Blakenburg and @FormR - thankyou both, that works as needed. Really appreciate the fast response and solution.

 

[Alex Blakenburg]

You're welcome. Glad we could help.