JumboCactuar
Wellknown Member
 Joined
 Nov 16, 2016
 Messages
 773
 Office Version

 365
 Platform

 Windows
Hi,
i use these formulas quite a lot for looking up previous match
is there a more efficient way? As these seem to slow everything down
Formulas below are based on text data in column A, and values in Column B
Lookup Column C
Someone on Reddit gave me this alternative
Index Column D
Source: https://www.reddit.com/r/excel/comments/ak3r8k/anything_faster_than_lookup21/
Both produce similar speeds, is this realistically the fastest I'm gonna get with formulas?
Can anyone come up with anything quicker?
i use these formulas quite a lot for looking up previous match
is there a more efficient way? As these seem to slow everything down
Formulas below are based on text data in column A, and values in Column B
Lookup Column C
Code:
=LOOKUP(2,1/($A$1:A2=A2),$B$1:B2)
Someone on Reddit gave me this alternative
Index Column D
Code:
=IFERROR(INDEX(B$1:B1,1/(1/MAX(INDEX((A$1:A1=A2)*ROW(A$1:A1),)))),"")
Source: https://www.reddit.com/r/excel/comments/ak3r8k/anything_faster_than_lookup21/
Both produce similar speeds, is this realistically the fastest I'm gonna get with formulas?
Can anyone come up with anything quicker?