+ Reply to Thread
Results 1 to 4 of 4

Formula to show a cells contents based on another cell being selected from a formula

  1. 10-19-2016, 08:11 AM #1
    tigerpie
    tigerpie is offline
    Registered User
    Join Date
    02-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2007
    Posts
    22

    Formula to show a cells contents based on another cell being selected from a formula

    Hello,
    I have a spreadsheet where the top row are dates. the first columns are budgets descriptions and the middle / contents are all figures of when the things on the first column have to be paid.... This is a budget..
    Anyway, I have this formula =MIN(BS37:UK37) shows me the smallest number in the rows... however I would also like to know what date that is on.
    SO I would like another formula that shows me the contents of DN1 (which is a date) if the result of the first formula is DN37

    Sorry if that doesnt make sense.....

    I have attached a pic of hte end result.
    As I said, I have the formula for cell A3, I just need the formula for cell B3
    TIA
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 10-19-2016, 08:17 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,221

    Re: Formula to show a cells contents based on another cell being selected from a formula

    Based on the formula used in the image in A3:

    =MIN(C2:G2)

    this in B3:

    =INDEX(C1:G1,0,MATCH(A3,C2:G2,0))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-19-2016, 08:34 AM #3
    tigerpie
    tigerpie is offline
    Registered User
    Join Date
    02-17-2012
    Location
    sydney
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Formula to show a cells contents based on another cell being selected from a formula

    THank you very much for that AliGW, Very much appreciated.
    Reply With QuoteRegister To Reply
  4. 10-19-2016, 08:43 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,221

    Re: Formula to show a cells contents based on another cell being selected from a formula

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countif formula show error when Run code on Selected cells
    By internet_imran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2015, 07:46 AM
  2. [SOLVED] Formula to capture contents in one of 2 cells based on Yes or No in another cell
    By Squint in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2014, 01:27 PM
  3. [SOLVED] Formula Find Specified Text show contents of the cell below
    By keen2xl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2014, 04:43 PM
  4. [SOLVED] show a certain value in the selected cell based on the selected item no. and month
    By pphg in forum Excel General
    Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  5. Help with a Formula to Populate one Cell Based on the Contents of A range of Cells
    By Squint in forum Excel General
    Replies: 2
    Last Post: 01-26-2011, 11:16 AM
  6. Don't want text for selected cell to show up in formula bar.
    By lukasj13 in forum Excel General
    Replies: 2
    Last Post: 04-02-2008, 11:09 PM
  7. [SOLVED] Is there a formula to show which cell is currently selected
    By Chris in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2006, 10:40 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1