EXCEL query and export as a new table

Using the vlookup function can completely solve your problem. For details, please refer to excel help.

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value needs to be in a table array (array: used to create multiple results or can be arranged in rows and columns A single formula that operates on a set of parameters. An array range uses a formula; an array constant is a set of constants that are used as parameters to find the values ??in the first column. Lookup_value can be a numeric value or a reference. If lookup_value is less than the smallest value in the first column of table_array, VLOOKUP returns the error value #N/A.

Table_array is two or more columns of data. Please use a reference to the zone or the zone name. The value in the first column of table_array is the value searched for by lookup_value. These values ??can be text, numbers, or logical values. Not case sensitive.

Col_index_num is the column number of the matching value to be returned in table_array. When col_index_num is 1, the value in the first column of table_array is returned; when col_index_num is 2, the value in the second column of table_array is returned, and so on. If col_index_num : is less than 1, VLOOKUP returns the #VALUE! error value. Greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.

Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match: If TRUE or omitted, an exact match or an approximate match is returned. That is, if an exact match is not found, the largest value less than lookup_value is returned.

The values ??in the first column of table_array must be sorted in ascending order; otherwise VLOOKUP may not return the correct values. You can sort these values ??in ascending order by selecting the Sort command on the Data menu and then selecting Ascending. For more information, see Default sort order. If FALSE, VLOOKUP will only look for exact matches. In this case, the values ??in the first column of table_array do not need to be sorted. If two or more values ??in the first column of table_array match lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.