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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Problem

  • 03-07-2002 8:55am
    #1
    Cork
    Registered Users, Registered Users 2 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

  • #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.


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


    The Insert Word thing worked in Word.

    I think the lookup thing would also work. Tahnks!


Advertisement