Hi Declan,

Maybe I misunderstood your explaination, but what results is just
####'s.

The formula appears to be looking in column F:F for something, and not
returning anything. I'm a bit concerned with the use of ABS since the
values I may need must be positive only or match closely to the target
values in A1 and B1

I can separate the data on a single sheet, maybe the double sheet thing
has me out to lunch.
Again maybe I don't understand and I'm trying to use this wrong, so any
help you could give would be appreciated.

Thanks,

Bob