Hi Guys,
I have a bunch of unique identification numbers and the ID numbers cannot be used more than once.
ID number eligibility is determined by the index/match function (4 criteria). (formula works up to this point)
{=INDEX(Table!$A$4:$AT$80,MATCH(1,(Table!$K$4:$K$80=K11)*(Table!$AT$4:$AT$80=M11)*(Table!$N$4:$N$80=O11)*(Table!$AQ$4:$AQ$80='1st result fail'!B11),0),1)}
Where the formula falls apart is that it will only return the first ID number that meets the criteria. I need it to return a unique ID number that meets the index/match function criteria each time.
Any ideas?
Sincerely,
Taylor
Bookmarks