Many thanks again Tom,
The criteria for the pricing columns was the same for the repairs. i.e.
the prices from a priority quote OR The latest information from the next
priority down if its missing from the top priority quote.

I dont think I gave an example in the worksheet, but what I mean is:
If a price is given on a top priority quote, but no lead time is given,
take the price from the top quote but the lead time from the next latest
quote.

Hope that makes sense!

Cheers.


--
QuickLearner
------------------------------------------------------------------------
QuickLearner's Profile: http://www.excelforum.com/member.php...o&userid=35483
View this thread: http://www.excelforum.com/showthread...hreadid=552634