+ Reply to Thread
Results 1 to 4 of 4

Excel Formula question pulling certain cell based off another

  1. #1
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    Excel Formula question pulling certain cell based off another

    Hello,

    Please see workbook for question.

    "Enter the value 1,2,3, etc. to correspond to January, February, March, etc..

    In this example I entered 1 in cell C10 and want it to pull the $65,486.00 into the cell below (C11). What is a formula I could use to accomplish this?"

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Excel Formula question pulling certain cell based off another

    Where do you get $65,486.00 from?

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Excel Formula question pulling certain cell based off another

    Asking for a result for $65,486.00 must be an error, as 50 is the one available.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You have C10 formatted as text, format it as general

  4. #4
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    Re: Excel Formula question pulling certain cell based off another

    Sorry, I meant $50.00. Thank you!

+ 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] Basic Question - Pulling the value of a Excel Cell into a macro
    By SL_Mills in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2015, 11:32 AM
  2. Replies: 1
    Last Post: 02-17-2014, 11:21 PM
  3. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  4. Question re. pulling HTML into Excel
    By ngalunic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-22-2012, 03:05 AM
  5. Replies: 1
    Last Post: 04-29-2011, 06:16 AM
  6. [SOLVED] Formula question-change formula based cell calling it?
    By seethesun in forum Excel General
    Replies: 2
    Last Post: 02-08-2009, 01:39 PM
  7. Newbie question Pulling data from one sheet to another based on
    By Tony Canevaro in forum Excel - New Users/Basics
    Replies: 16
    Last Post: 10-25-2005, 10:05 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