How to match 3 columns into 2 different sheets

How to match 3 columns into 2 different sheets

There are many ways we can do this, but it depends on the data structure and what the user wants as the final output. The spreadsheet can be complex by having more than one column or having only one column. For a simple data set, we can use basic options. Use matches Formula =MATCH(A2,$E$2:$E$7,0) That's