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
Report 2
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 |