November 2, 2017
i am stuck with this formula because it calculates heavily every time it's run, isnt there an easier process?.
What it currenltly does is check if a word is in f.i. cell AJ6711, compares it to the list of entires in AY and returns the value behind it. 67 words in total with the target it needs to give in the cell next to it...
=IFERROR(INDEX('Auto Approved Interco'!$AZ:$AZ, AGGREGATE(16, 6, ROW($3:$70)*SIGN(MATCH("*"&'Auto Approved Interco'!$AY:$AY&"*", AJ6711, 0)), 1)),"Not found")
Thnaks ! Ralph