Compare 2 tables and list unmatched/missing row

[kkvaas]

How can I use Table 1 as reference and find any missing row in tables 2 to display in another cell or worksheet? For Booking column, there will be same ID sometimes with different First name and Last Name.
I know it can be done by power query, but both tables will change data up to 50 rows as I switch to different product section. I am trying to avoid clicking Refresh All for query
Is there a way to do it with Formulas? So I can missing row result immediately.

 

[Peter_SSs]

Welcome to the MrExcel board!

You will generally get faster & better answers if you provide sample data in a form that can easily be copied for testing:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Doe this do what you want?

22 08 06.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Booking	First Name	Last Name			Booking	First Name	Last Name	Gender
2	1	A	B			3	E	F	F		Missing
3	1	C	D			1	A	B	M		Booking	First Name	Last Name	Gender
4	3	E	F								1	C	D
5	4	G	H								4	G	H
6
Missing

Cell Formulas
Range	Formula
K4:M5	K4	=FILTER(A2:C50,ISNA(MATCH(A2:A50&"|"&B2:B50&"|"&C2:C50,F2:F50&"|"&G2:G50&"|"&H2:H50,0)),"")
Dynamic array formulas.