In order to keep functionality simple, I think it would be easiest to keep it to all items listed in the lot field.  If there are other items in that lot with differing condition, then those could be made as a separate list to run the lot and the appropriate condition selected for valuing that new list with that condition.