• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Fábio Negreiros

    Vlookup using array as looked up value - Google Sheets to O365Migration

    Thank you SirJb7, I'll prepare a example because I can't post the original file. I'll send later today.
  2. Fábio Negreiros

    Hello .. Introduce yourself

    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.
  3. Fábio Negreiros

    Vlookup using array as looked up value - Google Sheets to O365Migration

    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...
Back
Top