LOOKUP Data across a range of cells to meet a specific criteria.

Jacc,

That's brilliant, many thanks for your efforts. I've applied this to a much larger stock list and it's working exactly as I was hoping it would.

Thanks again,
Adam.