Index - Match inquiry

[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??

Thank you.

 

[awoohaw]

@Murad_ Mr. excel has a tool, xl2bb add in that allows you to post mini sheets, the link is below.
If you cannot use that then please post your data in a table (label columns and rows please).

You're asking the forum to recreate your scenario and the forum could make a typo or other type of error that will cause delays in providing you with a solution.

Please help the forum help you.

Thanks in advance.