INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally

The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.

The COUNT function allows you to count a range of cells that contain numeric values. COUNTA goes one step further.