excell help needed "autofill" - boards.ie
Boards.ie uses cookies. By continuing to browse this site you are agreeing to our use of cookies. Click here to find out more x
Post Reply  
Thread Tools Search this Thread
20-11-2012, 19:16   #1
Phil dublin
Join Date: Dec 2009
Posts: 106
excell help needed "autofill"

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.
Phil dublin is offline  
20-11-2012, 21:14   #2
Registered User
oxysept's Avatar
Join Date: Dec 2010
Location: Ireland, West Coast
Posts: 48
Vlookup or Hlookup function formal my help
oxysept is offline  
20-11-2012, 21:41   #3
Phil dublin
Join Date: Dec 2009
Posts: 106
Originally Posted by oxysept View Post
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.
Phil dublin is offline  
22-11-2012, 22:20   #4
Registered User
Join Date: Aug 2009
Posts: 398
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
frogstar is offline  
23-11-2012, 00:25   #5
Registered User
Join Date: Jan 2009
Posts: 312
Match & index

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).
onimpulse is offline  
Post Reply

Quick Reply
Remove Text Formatting

Insert Image
Wrap [QUOTE] tags around selected text
Decrease Size
Increase Size
Please sign up or log in to join the discussion

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Share Tweet