Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I have tried 2 formulas (below) and neither work. Can Vlookup and Hlookup be combined to locate the data I'm looking for or will it require an indirect/match formula?
The data pictured below is in the tab marked MON (Monday). I would like a formula that would search by a) the name in COL A and then b) search that row to locate the column in which "B1" (first break) appears. The formula would then display the data in the time row (Row 59 in this example but that can change). I feel this can be done without VBA but I'm just not getting anywhere. All help would be greatly appreciated.
=IFERROR(INDEX(MON!$B$59:$AQ$59,MATCH(F11,INDEX(MON!$B$7:$AQ$31,MATCH(A2,MON!$A$7:$AQ$31,0),),1)), "Not Found")
=VLOOKUP(Sheet4!A2,MON!A7:AQ58,HLOOKUP(Sheet4!B1,MON!B7:AQ59,2,FALSE),FALSE)
The data pictured below is in the tab marked MON (Monday). I would like a formula that would search by a) the name in COL A and then b) search that row to locate the column in which "B1" (first break) appears. The formula would then display the data in the time row (Row 59 in this example but that can change). I feel this can be done without VBA but I'm just not getting anywhere. All help would be greatly appreciated.
=IFERROR(INDEX(MON!$B$59:$AQ$59,MATCH(F11,INDEX(MON!$B$7:$AQ$31,MATCH(A2,MON!$A$7:$AQ$31,0),),1)), "Not Found")
=VLOOKUP(Sheet4!A2,MON!A7:AQ58,HLOOKUP(Sheet4!B1,MON!B7:AQ59,2,FALSE),FALSE)