L
Lversteeg
I am hoping someone can help me!!!!
I have on one sheet a product selector for my sales team. I have added a
I have on one sheet a product selector for my sales team. I have added a
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernie Deitrick
In cell A1, array enter (enter using Ctrl-Shift-Enter) the formula
=INDEX(ProductSelector!$I:$I,SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1)))
and copy down.
You can hide the error values by using this slightly more complicated version:
=IF(COUNTIF(ProductSelector!R:R,"X")>=ROWS($B$1:B1),INDEX(ProductSelector!$I:$I,
SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1))),"")
HTH,
Bernie
MS Excel MVP
=INDEX(ProductSelector!$I:$I,SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1)))
and copy down.
You can hide the error values by using this slightly more complicated version:
=IF(COUNTIF(ProductSelector!R:R,"X")>=ROWS($B$1:B1),INDEX(ProductSelector!$I:$I,
SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1))),"")
HTH,
Bernie
MS Excel MVP
B
Bernie Deitrick
In cell A1, array enter (enter using Ctrl-Shift-Enter) the formula
=INDEX(ProductSelector!$I:$I,SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1)))
and copy down.
You can hide the error values by using this slightly more complicated version:
=IF(COUNTIF(ProductSelector!R:R,"X")>=ROWS($B$1:B1),INDEX(ProductSelector!$I:$I,
SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1))),"")
HTH,
Bernie
MS Excel MVP
=INDEX(ProductSelector!$I:$I,SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1)))
and copy down.
You can hide the error values by using this slightly more complicated version:
=IF(COUNTIF(ProductSelector!R:R,"X")>=ROWS($B$1:B1),INDEX(ProductSelector!$I:$I,
SMALL(IF(ProductSelector!$R$12:$R$100="X",ROW(ProductSelector!$R$12:$R$100)),ROWS(B$1:B1))),"")
HTH,
Bernie
MS Excel MVP
L
Lversteeg
Thanks Bernie, I can't get it to calculate correctly though. The Product
Selector has a completely different layout than the Quote and I only want
certain information for there to be taken to the quote. And when I get to the
prices there are too many IF's to incorporate the formula that you sent me.
Thanks anyway
Selector has a completely different layout than the Quote and I only want
certain information for there to be taken to the quote. And when I get to the
prices there are too many IF's to incorporate the formula that you sent me.
Thanks anyway
L
Lversteeg
Thanks Bernie, I can't get it to calculate correctly though. The Product
Selector has a completely different layout than the Quote and I only want
certain information for there to be taken to the quote. And when I get to the
prices there are too many IF's to incorporate the formula that you sent me.
Thanks anyway
Selector has a completely different layout than the Quote and I only want
certain information for there to be taken to the quote. And when I get to the
prices there are too many IF's to incorporate the formula that you sent me.
Thanks anyway
B
Bernie Deitrick
Post a little bit of your data, and describe what you would want returned.
Bernie
Bernie
B
Bernie Deitrick
Post a little bit of your data, and describe what you would want returned.
Bernie
Bernie