+ Reply to Thread
Results 1 to 4 of 4

Pull value from one cell based on the value of another cell and display it in a third cell

  1. #1
    Registered User
    Join Date
    12-07-2014
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel for mac 2011 14.4.4
    Posts
    2

    Pull value from one cell based on the value of another cell and display it in a third cell

    This is probably very easy but I have no idea how to do this and I don't know what to google to find the answer.

    In the attached file I am trying to do the following.

    1. Enter a quantity in cell F3. For example "3"
    2. I want cell J3 to pull the number "3" from F3 > look at sheet 2 "Print Size & Quantity" > find the price for the 8x8 print QTY 3. In this example it is cell B5 and the value is $5.44.
    3. I want cell J3 to display the value from sheet 2 cell B5 > "$5.44"

    I know this is basic stuff. sorry.

    Pricing.xlsx

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Pull value from one cell based on the value of another cell and display it in a third

    J3=IFERROR(INDEX('Print Size & Quantity'!$B$2:$G$21,MATCH($F3,'Print Size & Quantity'!$A$2:$A$21,0),MATCH($D3,'Print Size & Quantity'!$B$1:$G$1,0)),"")
    and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    12-06-2014
    Location
    Nottingham
    MS-Off Ver
    2010
    Posts
    9

    Re: Pull value from one cell based on the value of another cell and display it in a third

    or J3=IF(ISNUMBER(F3),IF(ISERROR(VLOOKUP(F3,'Print Size & Quantity'!A:G,2,)), "out of scope",VLOOKUP(F3,'Print Size & Quantity'!A:G,2,)),"please enter number")

  4. #4
    Registered User
    Join Date
    12-07-2014
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel for mac 2011 14.4.4
    Posts
    2

    Re: Pull value from one cell based on the value of another cell and display it in a third

    Thank you nflsales! That worked great. I would have never figured that out.

+ 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. [ASK] Display Cell Values Based On Cell Colour
    By cyber28 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2013, 11:48 PM
  2. Display data from multiple cell in a single cell, based on criteria
    By Mothman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-08-2012, 07:24 AM
  3. Replies: 2
    Last Post: 06-08-2011, 02:36 PM
  4. Replies: 2
    Last Post: 09-15-2010, 11:59 AM
  5. Making a cell display info based on another cell.
    By bjordan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2007, 03:46 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