+ Reply to Thread
Results 1 to 2 of 2

HELP with excel auto populate by looking up a date and entering a pre-determined value

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    1

    HELP with excel auto populate by looking up a date and entering a pre-determined value

    I am creating a budget tracking spreadsheet and enter financial spending values to keep track of finances.
    In column A I have the days of the year listed from 1st January 2014 to 31 December 2014.
    I am looking for a formula to automatically populate the value of a particular spend for the rest of the year.
    Example: Where I am aware that a phone bill is payable on the same day each month (say 25th), I would like to include a formula in Column B which has the cost each month to include a value of say £25 to be included in the relevant cell corresponding with the 25th of each month in column A.

    Does anyone know of a formula in can include to look up the date in column A and enter a corresponding value in column B under that heading (Phone Bill)?

    I have attached a spreadsheet with the headings to demonstrate.

    HELP
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: HELP with excel auto populate by looking up a date and entering a pre-determined value

    =if(day(a2)=25,25,0)
    Click * below if this answer helped

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto Populate Excel Calendar based on Date Ranges
    By mikearmanios in forum Excel General
    Replies: 14
    Last Post: 04-01-2021, 12:11 PM
  2. Replies: 0
    Last Post: 07-18-2013, 11:43 AM
  3. how can i auto populate date in excel?
    By CRS- in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 08:23 AM
  4. how do you auto populate the date in excel?
    By ccb/ws in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-13-2006, 02:50 PM
  5. HOW ?Excel chart auto insert /populate a code based on date
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-22-2005, 08:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1