EXCEL uses function joint debugging (find, mid, vlookup, xlookup)

Use xlookup data filter

• Use the XLOOKUP function to find table or range content by row.For example, find the price of a car part by part number, or find an employee's name by employee ID.With XLOOKUP, you can look up a search term in one column and return results in another column on the same row, no matter which side of the original column the result is returned from.

Use vlookup

• The VLOOKUP function is a vertical search function in Excel. It belongs to a class of functions with the LOOKUP function and the HLOOKUP function. It is widely used in work, for example, it can be used to check data and quickly import data between multiple tables.function function.The function is to search by column, and finally return the value corresponding to the query sequence required by the column; the corresponding HLOOKUP is searched by row

Using the find fuzzy query function

Use the mid function to extract the value