Hello, I have a formula on an invoice that retrieves data with a vlookup to be able to say "Tuition for e-learning course "Gender Mainstreaming."
=IFERROR("Tuition for the e-learning course """&VLOOKUP(D17,InvoicesDue!$B:$X,11,FALSE)&"""","")
I want to add in a part so that it would automatically say "Tuition for auditing e-learning course "Gender Mainstreaming"" in the case of auditors, and I can add in the word "auditing" to the invoicesdue sheet so that becomes part of the formula. This seems like it almost works when I just change it to be
=IFERROR("Tuition for "&VLOOKUP(D17,InvoicesDue!$B:$X,7,FALSE)&"the e-learning course """&VLOOKUP(D17,InvoicesDue!$B:$X,11,FALSE)&"""","")
but I can't get the spacing right for both auditors and non auditors (if the "auditing" cell is empty or not"). If I make the spacing work when the word "auditing" is there, then there's an extra space for non auditors.
Please help!
Thank you!
Bookmarks