How to Use INDEX and MATCH for Flexible Lookups in Google Sheets
INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally
top of page
Aug 13, 20225 min read
INDEX Function in Google Sheets
The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.
5010
Jul 30, 20223 min read
COUNT and COUNTA Functions
The COUNT function allows you to count a range of cells that contain numeric values. COUNTA goes one step further.
1110
bottom of page