Results 1 to 3 of 3

Return Value in Cell from Table

Threaded View

Prof Sick Return Value in Cell from... 01-01-2018, 01:52 PM
mike7952 Re: Return Value in Cell from... 01-01-2018, 02:26 PM
Prof Sick Re: Return Value in Cell from... 01-01-2018, 02:52 PM
  1. #1
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Return Value in Cell from Table

    In the B14 cell, I need to have excel return the value in the D column that associates with Lot in the A column within the WT1 & Wt2 Range. This would be relative to Lot entered into the B12 cell and the within the ranges in the B2:C7 array.

    For example, with the values entered in on the attached spreadsheet, B12 & B13, $1.05 would be returned to B14.

    Thanks ahead of time for your help. Happy New Years!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search cell for words in table and then return table header
    By leovfx in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-01-2017, 05:59 PM
  2. [SOLVED] Using CSV cell values to reference a table and return matches in CSV format in new cell
    By fjyoder in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2017, 07:10 PM
  3. LOOKUP TABLE -blank cell in the table array to return a figure
    By jonnops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2014, 09:08 AM
  4. Lookup value in a table, return cell below
    By burlywood66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2013, 11:16 AM
  5. Replies: 0
    Last Post: 01-23-2012, 05:16 PM
  6. Return total in pivot table regardless of cell
    By ndenaro in forum Excel General
    Replies: 5
    Last Post: 07-14-2009, 03:31 PM
  7. Return the address of cell table
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 07:05 PM

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