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
Banned
 
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  
Advertisement
20-11-2012, 21:14   #2
oxysept
Registered User
 
oxysept's Avatar
 
Join Date: Dec 2010
Location: Ireland, West Coast
Posts: 46
Vlookup or Hlookup function formal my help
oxysept is offline  
20-11-2012, 21:41   #3
Phil dublin
Banned
 
Join Date: Dec 2009
Posts: 106
Quote:
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
frogstar
Registered User
 
Join Date: Aug 2009
Posts: 316
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
onimpulse
Registered User
 
Join Date: Jan 2009
Posts: 276
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
Message:
Remove Text Formatting
Bold
Italic
Underline

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