Solved: Tricky formula help?

[Simon Lloyd]

Hi all, i am using data validation drop down (B13) to supply some data eg. ABC 123, i want to be able to find the row that this appears on in column B and then do something like the following:

in H2 i am using {=SMALL(IF($B$1:$B$10=B13,ROW($B$1:$B$10)),ROW()-ROW($B$1))} to find the row the data appears on
=MIN(D&row(H2):f&row(H2))

I have tried using:
{=1*MID(B13,MATCH(TRUE,ISNUMBER(1*MID(B13,ROW($1:$10),1)),0),COUNT(1*MID(B1 3,ROW($1:$10),1)))} to extract just the number and use that.

Essentially i am trying to find the minimum value of a row containing the data found in the dropdown.

Any ideas?

[Shazam]

May we see an example of your workbook with the expected results.

[Simon Lloyd]

Sure see attached!

[RichardSchollar]

Hi Simon

I'm sure I'm missing something (you gave no expected result for example) but does the following do what you want:

=MIN(INDEX($D$2:$G$10,MATCH(B13,MVals,0),0))

[Simon Lloyd]

Richard, Yes! looking at that now i see i was missing something.....how does the saying go...........couldn't see the wood for the trees!