Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
51
Views
Topic starter
Hi all
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
Posted : 03/11/2017 9:49 am
Sorry, no replies, but maybe you can give us a sheet with the working you have and you want in it? Maybe that'll help answering the question!
Posted : 09/11/2017 1:58 pm
