ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Match, Index, Not sure (https://www.excelbanter.com/excel-discussion-misc-queries/264015-match-index-not-sure.html)

Dale G[_2_]

Match, Index, Not sure
 

Im 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. Im 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.



All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com