In this mode, MATCH will “step back” to the last numeric value.
For other situations (text values, etc.
), see other “last row” formulas mentioned below.
You will need to adjust the MATCH part of the formula to suit your needs.
For row number, we give INDEX the result returned by MATCH + 1. it’s possible for you to use HYPERLINK to create a clickable hyperlink with a formula.
The pop in of information to be returned is specified asinfo_type.
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
