Home/ Questions/Q 14107
Next
Answered
computing
  • 1
Asked: 2021-12-14T07:55:14+00:00 In:

Solved How To Bold Text In An Excel Formula

  • 1

I would like to bold the outcome of the Last Vlookup applied in the below formula ,

=”We have received a request from “,’Final Output’!C3&” ( “&’Final Output’!B3&” ) for a Tax IT project that needs your approval . If you have any questions about this Business Case you can contact <Requestor Name>(Requestor) or”&” “&VLOOKUP;(‘Final Output’!A3,’Pipeline Data’!A:ET,148,FALSE)&”( TBT ) “&” (Both Copied) “

Share

    1 Answer

    1. Best Answer
      BTW…your formula produces an error. I think you have a comma where there should be an &.

      You have: =”We have received a request from “,‘Final Output’!C3…

      I believe that should be: =”We have received a request from “&‘Final Output’!C3…

      In addition, at the end of the formula you have:

      &”( TBT ) “&” (Both Copied) “

      Couldn’t that be written as:

      &”( TBT ) (Both Copied) “

      It looks like you’re concatenating 2 text strings.

      Let me know if I missed something.

      How To Post Data or Code —> Click Here Before Posting Data or VBA Code

      • 0