Can anyone help me figure out how to use the offset function inside a vlookup?
eg. if this was the table (table also attached)
Row 1: Group 1 | Parameter 1 | A B C
Row 2: | Parameter 2 | D E F
Row 3: | Parameter 3 | G H I
How would i vlookup "Group 1" and return "F" ?
Appreciate any help.
Bookmarks