Hi All,
I hope one of you experts out there can help me. My current formula is this:
{=INDEX(LOCSPC!N:N,MATCH(1,(LOCSPC!T:T=BINTRAN!AE2)*(LOCSPC!C:C>=BINTRAN!Z2)*(LOCSPC!C:C<=BINTRAN!AA2)*(LOCSPC!D:D<BINTRAN!X2)*(LOCSPC!I:I>=BINTRAN!AC2),0))}
Or to simplify:
{=INDEX(Array,MATCH(1,(Criteria 1)*(Criteria 2)*(Criteria 3)*(Criteria 4)*(Criteria 5),0))}
Right now the formula returns the first value that matches the criteria from a sorted array. Basically I'd like to adjust this formula to return the Nth result i.e. the 2nd, 3rd, 4th, etc. result.
I looked up the formula below online which is fine for a single criteria but I need it for multiple criteria and I'm not sure how to adjust. Any help would be greatly appreciated!!!
{=INDEX(array,SMALL(IF(vals=val,ROW(vals)-ROW(INDEX(vals,1,1))+1),nth))}