D
Dale G
I’m trying to return a value in cell B2 by matching the values in C2 & D2.
The values of C2 & D2 would use a lookup table on a different sheet, named
Saturday form A3:AP27.
C2 is 510n & D2 is 5:47. I’m hoping to retrieve the value in column A of the
lookup table when those two match in the same row.
The lookup table will have 510n in many different cells throughout the table
and 5:47 may be in the table more than once, but somewhere within the table
the two will be side by side in the same row, (example K4 & L4) and retrieve
the value in A4.
Hope this explanation makes some sort of sense.
The values of C2 & D2 would use a lookup table on a different sheet, named
Saturday form A3:AP27.
C2 is 510n & D2 is 5:47. I’m hoping to retrieve the value in column A of the
lookup table when those two match in the same row.
The lookup table will have 510n in many different cells throughout the table
and 5:47 may be in the table more than once, but somewhere within the table
the two will be side by side in the same row, (example K4 & L4) and retrieve
the value in A4.
Hope this explanation makes some sort of sense.