I am trying to produce a frequency pf pick table using a customer's product master file and a sales volume file and have got some peculiar results. Where, for example, a product code appears in the sales volume file but not in the product master file, the lookup returns the description for the next nearest product code above it. I hope that makes sense.

So, is there a way to return, say, 'Not in pmf' instead of the erroneous description or perhaps even " " (as a blank)?

Help greatly appreciated please.

heFFers