![]() |
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