Hey - I am trying to do an index match for multiple criteria. My issue is that the 2nd criteria are date ranges. What I am trying to determine is if there is a match in the P2 cell and column C:C in the "Auths" sheet, then look to see if the date in cell J2 is within the date range of columns E:F on the "Auths" sheet. Note - there's 2 columns for a start date and an end date.
Any idea if I am able to do this through an index match? Here's what I've written so far:
=INDEX(Auths!C:C,MATCH('UMD074,UMD063,UMD010'!P2,Auths!D:D,0))
Thanks for your help
Any idea if I am able to do this through an index match? Here's what I've written so far:
=INDEX(Auths!C:C,MATCH('UMD074,UMD063,UMD010'!P2,Auths!D:D,0))
Thanks for your help