Non-Helper Formula based on example
![]()
C19: =LOOKUP(2,1/(($E19&$F19&$G19&$H19=List1!$B$2:$B$100&List1!$C$2:$C$100&List1!$D$2:$D$100&List1!$E$2:$E$100)),List1!$A$2:$A$100)
Non-Helper Formula based on example
![]()
C19: =LOOKUP(2,1/(($E19&$F19&$G19&$H19=List1!$B$2:$B$100&List1!$C$2:$C$100&List1!$D$2:$D$100&List1!$E$2:$E$100)),List1!$A$2:$A$100)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks