Howdy folks! First, here's my current formula:
=IFERROR(INDEX(Calendar!$A$2:$A$35,MATCH('Staff List'!B14,Calendar!$B$2:$B$35,0)),"")
This formula works currently, but is there a way to have the lookup_array portion of the MATCH do a validation check?
i.e. MATCH(lookup value,if this criteria is met then lookup is column B, rows 2-35, if this criteria is met, column C, rows 2-35, etc,0)?

I couldn't find anything online and my attempts at having an INDEX/MATCH formula with multiple Match criteria over diff tabs/diff range sizes was a no go.

Any advice would be appreciated!