1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • how to get =IF(ISERROR(MATCH(G13,Events!$G:$G,0)),"" ,INDEX(Events!$A:$

    From [email protected]@21:1/5 to All on Wed Aug 3 05:52:45 2022
    how to get =IF(ISERROR(MATCH(G13,Events!$G:$G,0)),"" ,INDEX(Events!$A:$A,MATCH(G13,Events!$G:$G,0))) to return font and alignment along with the text in excel

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auric__@21:1/5 to [email protected] on Wed Aug 3 15:28:59 2022
    [email protected] wrote:

    how to get =IF(ISERROR(MATCH(G13,Events!$G:$G,0)),"" ,INDEX(Events!$A: $A,MATCH(G13,Events!$G:$G,0))) to return font and alignment along with the text in excel

    Pretty sure that's not possible with just formulae. I believe it would need
    to be done in VBA.

    --
    - Why are we pursuing the Entity, if not to destroy it?
    - We are not hunters, Doctor. Nor is it our role to exact revenge.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Philip Herlihy@21:1/5 to All on Thu Aug 4 12:27:14 2022
    In article <[email protected]>, Auric__ wrote...

    [email protected] wrote:

    how to get =IF(ISERROR(MATCH(G13,Events!$G:$G,0)),"" ,INDEX(Events!$A: $A,MATCH(G13,Events!$G:$G,0))) to return font and alignment along with the text in excel

    Pretty sure that's not possible with just formulae. I believe it would need to be done in VBA.

    Just so. The value and format of a cell are independent, though copy operations ("Paste Special") can be set to copy both.

    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)