Hi! My name is Fábio Negreiros!
I'm a Project Manager at Microsof, based in Brazil.
I'm working with excel since ever, and I consider myself a VBA & automation expert. Please feel free to ask for help. I'll be glad to assist anyone.
Hello Everyone,
I've being trying for the last two days to find an alternate solution to this problem.
The formula itselft is quite simple:
On Google Sheet:
IFERROR(JOIN(CHAR(10), ArrayFormula(VLOOKUP(SPLIT($G2, ", ", FALSE), 'NIST 800-53r4'!$B$2:$F$1681,3, FALSE ))))
The above formula...