Returning Values for ALL Months from Specific Month Data and specific segment using Index & Match

[Murad_]

Hello There,
Reference to the attached sheet, what is the best formula that I can use in Dashboard tab in Cell AL30 to check in Extract tab if there are figures for that specific month and to return it for specific segment, for instance in AP30 in Dashboard tab, it returns the Occupancy for Weekday for May 2022 for My Prop as Total not segment, another instance the cell AP31 in Dashboard tab, it returns the occupancy of Trans Weekday for my Prop, so, what is the best excel formula that I can use to return the values for all month??

I couldn't upload the excel sheet.

Thank you.

 

[Fluff]

Duplicate to: Index - Match inquiry

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.