Find next price in data set

Hi calof1,

If you have Stock name selection in G2 and wish to list dates and prices for the selected product starting from range G3 for date and H3 for price, you can use the following formulas:

G3:  =IFERROR(INDEX($B$3:$B$7,SMALL(IF($A$3:$A$7=$G$2,ROW($B$3:$B$7)-ROW($A$2)),ROW(A3)-ROW($A$2))),"")

H3: =IFERROR(INDEX($C$3:$C$7,SMALL(IF($A$3:$A$7=$G$2,ROW($C$3:$C$7)-ROW($A$2)),ROW(A3)-ROW($A$2))),"")

Both formulas must be array entered in each cell . If you then copy these formulas down, the next rows will show next date/price combination for the selected product.

Please see the example attached

Thanks

Yury