I have a table of data, with unique rows and unique columns.
I need to be able to select a specific cell, if I provide the row and column specification. (Sort of a combination of Hlookup and Vlookup?) I need an answer that only provides exact matches.
Example: if Column A had names of people, and Row 1 had months of the year, I want to be able to say "provide the value of Sam in September".
Thanks to anyone who can help with the formula.
Appreciate it. (and Happy Holiday to all)
I need to be able to select a specific cell, if I provide the row and column specification. (Sort of a combination of Hlookup and Vlookup?) I need an answer that only provides exact matches.
Example: if Column A had names of people, and Row 1 had months of the year, I want to be able to say "provide the value of Sam in September".
Thanks to anyone who can help with the formula.
Appreciate it. (and Happy Holiday to all)