Read this SQL ... this column. Subqueries, or subselect statements, are a way to use a result set as a resource in another query to limit or refine results. The alternative is often multiple ...

The INDEX formula doesn’t recognize column letters, so you must use numbers (counting from the left). The syntax for the MATCH function is: MATCH(lookup_value, lookup_array, [match_type]).