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 all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
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

MS Excel/OpenOffice Calc Question

  • 28-12-2010 9:21pm
    #1
    deman
    Registered Users, Registered Users 2 Posts: 1,672 ✭✭✭


    OK, here's what I need to do and as I'm not very bright, I'm hoping somebody smarter than me can help me out.

    I'm making a list on OpenOffice Calc in 3 columns, A, B and C. The data in B and C co-relate to the data in A and are not variable. A lot of the data is repeated and takes up a lot of time. So as I enter the data into Column A and press "enter", is there any way of setting up Columns B and C to fill up with the related data automatically after the initial entry.

    Is this clear?

    Thanks in advance.

    EDIT:

    BTW, the data is all text.


Comments

  • #2
    Snowbat
    Registered Users, Registered Users 2 Posts: 1,064 ✭✭✭Snowbat


    You could use vlookup. The vlookup table can be on another sheet if you want to keep things tidy:

    https://www.youtube.com/watch?v=rLp1ZjaGsK8


  • #3
    deman
    Registered Users, Registered Users 2 Posts: 1,672 ✭✭✭deman


    That looks to be exactly what I'm looking for. I'll try it out a little later.

    Thanks :=)


Advertisement