Howdy folks! First, here's my current formula:
This formula works currently, but is there a way to have the lookup_array portion of the MATCH do a validation check?Please Login or Register to view this content.
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!
Bookmarks