Results 1 to 7 of 7

Read data adjacent to Data Validation Source

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-21-2004
    Location
    Norwich, CT USA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Read data adjacent to Data Validation Source

    I’m trying to display the value from a cell next to a data validation source cell. I'm having trouble referring to named ranges while doing this.
    On sheet “data Entry” I have dependant Data Validation selection cells “WDdetails” and “WallDetails” (both with green fill in the attached file). I want cell E10 (red fill) to display the value from the cell adjacent to the source of WallDetails.
    The data comes from Sheet “Lists”

    For example if I select:
    “NOT weatherstriped NO storm” then
    “W/D one side only”
    I want to read .018 (from Lists:C2) in cell E10
    It works if in E10 I use formula:
    OFFSET(INDEX(ValData,MATCH(WallDetails,weatherstriped_OR_storm,0),MATCH(WDdetails,Lists!1:1,0)),,1)
    However, because I need to expand this data to include more choices I need the array in the first MATCH, “
    MATCH(WallDetails,weatherstriped_OR_storm,0)
    ” to be driven by WDdetails, not hard coded.
    I've tried a lot to sort this out this weekend and am at the cry uncle point.
    This is the closest I’ve come but it gives me a REF error:
    INDEX(ValData,MATCH(WallDetails,INDIRECT(SUBSTITUTE(WDdetails," ","_")),0),MATCH(WDdetails,Lists!1:1,0))
    Sorry for the crazy jargon but I’m trying to keep the terms in line with an old trade document.
    Thanks
    Robert
    Attached Files Attached Files
    Last edited by Hammer_757; 08-25-2013 at 10:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to read Chart Data source
    By gjcase in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2013, 09:17 AM
  2. [SOLVED] Data Validation - replace choices for multiple sheets of source data
    By mshaw1970 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 07:34 AM
  3. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 AM
  4. [SOLVED] External Data Source and Adjacent Column / Data
    By Tim Miller in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 06:25 PM
  5. [SOLVED] [SOLVED] specify date source for x-axis (adjacent to data column in Excel)
    By retired general in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2006, 08:15 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