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

excell help needed "autofill"

  • 20-11-2012 7:16pm
    #1
    Closed Accounts Posts: 111 ✭✭


    hi all, thanks for reading.

    trying to set up an excell sheet for food.

    what im trying to do is when i type in eggs for example, i want excell to auto fill the stats below, for carbs, protiens, fats ect.

    i know ive to progam it somehow, but how. if i set up all the foods im using on the next sheet, can i program excell to auto the data as i type rather than adding all the data every time.

    so as soon as i type, eggs, all the fields below at filled in at the same time.

    cheers for any help. using ms office 2007.
    :D


Comments

  • Registered Users Posts: 50 ✭✭oxysept


    Vlookup or Hlookup function formal my help


  • Closed Accounts Posts: 111 ✭✭Phil dublin


    oxysept wrote: »
    Vlookup or Hlookup function formal my help

    had a look at vlookup erlier, dont think itd whats im after.
    i want it to auto populate the 5 cells below.

    thanks for the help tho. im going to look into hlookup now.:D


  • Registered Users Posts: 709 ✭✭✭frogstar


    Would an IF formula work?

    So for the blank cells you want filled you will enter an if formula. So it is if cell equals eggs, return cell b (on second sheet) You will obviously have a number of variables (can enter as many as you like for say eggs, milk etc) to enter and will have to input the if formula on each cell (5)

    Not explained very well but if you start the formula excel should guide the data


  • Registered Users Posts: 350 ✭✭onimpulse


    I'd try the "if" statement first but if that doesn't work ie you have too many nested if statements / egg is only one option of 10+ then...

    try using an index function combined with a match function. ( match inside the index function).


Advertisement