Pull Values based on one column

**bjnockle** · 10-29-2013, 06:47 AM

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.

**XOR LX** · 10-29-2013, 06:51 AM

Hi,

One way is to change your formula in B4 to:

=IFERROR(1/(1/(INDEX(ProductList!$C$2:$C$11,MATCH(A4,ProductList!$A$2:$A$11,0)))),"")

and copy down as required.

Regards

**bjnockle** · 10-29-2013, 10:38 PM

XOR LX: How have you been? Thanks a million! The formula works like a charm.

**XOR LX** · 10-30-2013, 03:16 AM

Not bad, my old friend! And you?

Haven't seen you on the forum for a while.

Glad to have helped again.

Regards

Pull Values based on one column

LinkBack

Thread Tools

Rate This Thread

Display

Pull Values based on one column

Re: Pull Values based on one column

Re: Pull Values based on one column

Re: Pull Values based on one column

Thread Information

Users Browsing this Thread

Similar Threads

Pull a value out of a pivot table based to another sheet based on column and row headings

How can i pull a range of values in to a column based on a cell value

Pull unique values based on adjacent column

Pull row/column titles based on values inside an array

Pull 5 values into fields based on code name

Bookmarks

Bookmarks

Posting Permissions