Results 1 to 4 of 4

Pull Values based on one column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,012

    Pull Values based on one column

    I need help extracting values if conditions are met. When a value is selected from the dropdown in A1 (for example Eastern), products associated with that dropdown can be selected from A4:A14. If western is selected, products list for Western can be selected from the dropdown list for Western in A4:A14 as well.

    The formula I have set-up is pulling the values; nonetheless, cells that should be blanks are returning unintended values.

    I need a formula to accurately capture the values for products that have corresponding values listed. Desired output is in GREEN color in column D

    Sample file is attached.

    Thanks for the assistance.
    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. Replies: 1
    Last Post: 04-04-2013, 02:47 PM
  2. How can i pull a range of values in to a column based on a cell value
    By nickwh34 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2012, 05:13 AM
  3. Pull unique values based on adjacent column
    By freud1 in forum Excel General
    Replies: 9
    Last Post: 07-02-2012, 11:36 AM
  4. Pull row/column titles based on values inside an array
    By julzzzz in forum Excel General
    Replies: 1
    Last Post: 03-29-2012, 06:45 PM
  5. Pull 5 values into fields based on code name
    By sabes35 in forum Excel General
    Replies: 7
    Last Post: 07-26-2010, 07:50 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