So I created a UDF that behaves like MATCH or INDEX MATCH but only on one criteria. I wish I knew enough to redesign it to function on unlimited criteria (within reason obviously). Here it is:
Function quickcompare(itemtofind As Range, comprange As Range, Optional resultreturn As Range)...