BLACK FRIDAY SALE 20% OFF ALL COURSES

Ralph Heijden
New Member
Members

Forum Posts: 1
Member Since:
November 2, 2017
November 2, 2017

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Melissa Jamison, Pam Baillie, Todd Heckman
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 227
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Kelvin H
Anya Ledwith
Mark Melvin
Stuart McInnes
Naji Moukhachen
Robert Mason
Debora Cohen
Kris Whitaker
Rajesh Jawajala
Todd Heckman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6641
Posts: 29140
Member Stats:
Guest Posters: 49
Members: 33096
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
