I need to look up values in a tabel that has subtables.
Example:
35376 WEEK 22
MONTH 33
MIN 11
TTIN 44
35377 WEEK 55
MONTH 88
MIN 77
TTIN 99
I enter 35377, MIN and the function should then return 77
I cannot use the system where the WEEK, MONTH etc are in separate columns
such as
WEEK MONTH
35376 22 33
35377 55 88