{{
`${userDetail.user.displayName}${userDetail.user.cachedBungieGlobalDisplayNameCode ? `#${standardizeBungieGlobalCode(userDetail.user.cachedBungieGlobalDisplayNameCode)}` : ""}`}}
{{getUserClans()}}
8/20/2015 11:07:08 AM
5
I need a formula that can lookup text based off two criteria in different columns. I have tried using Index & Match but to no avail and my spreadsheet is quite big so I can't add another column with a combine function. Any suggestions?
English
-
Have you tried using the AND function with a VLOOKUP function as the true result?
-
Interesting, I've always avoided the TRUE outcome but this may be my use. I'll try when I'm back from my lunch.
-
Good luck. It does sound like you'd be better off using a database though.
-
Import it into a database, learn some proper skills son
-
We only use Excel and I'm not proficient enough yet in Macros to develop this from scratch.
