Auto Populate from drop down

**woodjl1650** · 01-27-2013, 01:03 PM

I have a budge excel doc that I would like to have my dropdown box populate the amount field when the correct bill is selected. I have a Data List Sheet where all my drop down box data is kept, then I have a bill sheet that has all my bills and amounts. I want the Fixed Bills to auto populate the Amount Field in the Expenditures & Income sheet.

Can this be done?

Thanks.

**alansidman** · 01-27-2013, 02:04 PM

In column J, try this and copy down

=IF(ISNA(VLOOKUP([@DESCRIPTION],Expenditures141511,2,FALSE)),"",VLOOKUP([@DESCRIPTION],Expenditures141511,2,FALSE))

**woodjl1650** · 01-27-2013, 02:16 PM

No luck...can you add it the attachment and re-submit, for some reason my excel does not like that (excel 2007)

**alansidman** · 01-27-2013, 02:33 PM

See attached.

Post back if you continue to have issues. You will notice that the non-fixed bills will have to be reentered.

**woodjl1650** · 01-27-2013, 07:09 PM

Would you be able to do the same thing but for the income amount (orange section) on the data list sheet and place it in the income section (blue section) of the Expenditures & Income?

Thanks again.

**alansidman** · 01-27-2013, 07:49 PM

Done. See Attached.

**woodjl1650** · 01-27-2013, 08:09 PM

Thanks for the help...

**alansidman** · 01-27-2013, 08:41 PM

Glad to have helped.
Alan

Auto Populate from drop down

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Re: Auto Populate from drop down

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions