M

#### mauddib

an array formula which I know not very much about....

{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$3500),(Sheet2!$J$3:$J$3500)))}

Its working almost perfectly. The only problem Im having is if the

values are, for example:

10

2

5

100

12

0

It will pick the 2 not the Zero.

I need to be able to pick the Zero in cases such as this. Does anyone

have hints on a tweak to the formula?

Gavin