Before jumping to VBA you should try replacing all the IFs in that formula with something like VLOOKUP or INDEX/MATCH.
Perhaps something like this.
Formula:
=IFERROR(INDEX(L4:L36, MATCH(E4,M4:M36,0)), "")
PS That's Scottish.
Before jumping to VBA you should try replacing all the IFs in that formula with something like VLOOKUP or INDEX/MATCH.
Perhaps something like this.
Formula:
=IFERROR(INDEX(L4:L36, MATCH(E4,M4:M36,0)), "")
PS That's Scottish.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks