Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Problem

Options
  • 03-07-2002 9:55am
    #1
    Cork
    Registered Users Posts: 3,924 ✭✭✭


    I seem to be having more trouble with excel. I am trying to put use mail merge from an excel document. That’s the easy part.

    I have about 15 codes in one column relating to individual paasages of text. How can I say – that if I have code 8 in the column that text 8 will pop up in an adjoining column?

    I was thinking of a =if statement.

    But, If I went into word – Could I use the If Else thing in the Insert merge text option in Mail Merge.
    If Column Y = 9 then insert text 9 else do nothing

    Would this work if I used this 15 or 16 times for my 16 codes.

    I apologise for my lack of knowledge of Excel. I must do an intermediate course on the thing.


Comments

  • Options
    #2
    Bucon
    Closed Accounts Posts: 94 ✭✭Bucon


    Sounds like something I'd use a lookup table for.

    Im sure you can find info on them online.


    Bucon.


  • Options
    #3
    Cork
    Registered Users Posts: 3,924 ✭✭✭Cork


    The Insert Word thing worked in Word.

    I think the lookup thing would also work. Tahnks!


Advertisement