you might 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.

Excel formula: Build hyperlink with VLOOKUP

MATCH supports approximate and exact matching, andwildcards(* ?)

Often, MATCH is combined with the…

Excel HYPERLINK function

Excel CELL function

Excel INDEX function

Excel MATCH function