+ Reply to Thread
Results 1 to 2 of 2

Formula for correlating cells based on a drop down

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    Oregon City, Oregon
    MS-Off Ver
    Excel 2013
    Posts
    4

    Formula for correlating cells based on a drop down

    I have a dropdown list (C1 on the dashboard sheet). When January is chosen in that list I want the value in D15 on the dashboard sheet to match the value in B13 on the Target sheet...and then the same for D16 on the dashboard sheet and B13 on the Actual Sheet. When February is chosen the values should match for the month and so on.

    Essentially I want the drop down list selection to populate the right numbers based on the month chosen. Let me know if i am not making sense.

    thank you for any help!

    TDCG Dashboard.xlsx
    Last edited by PittyPotts; 01-20-2014 at 01:34 PM. Reason: Mod

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: What formula do i use for this?

    Thread title adapted
    Last edited by Pepe Le Mokko; 01-20-2014 at 03:49 PM.

+ 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. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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