Unfortunately I cannot post even an image yet to this forum, but I will try and explain as best I could. I have a master column of part numbers with corresponding qty., then a column of order #'s of some of those part numbers(in next column) and order p/n qty's in next column. What I need, is to lookup if the ordered part number is in the master p/n list, and compare if the ordered qty is equal to or greater than the master p/n qty, if this is true, then paste the order number, p/n, and qty. I hope this makes sense, perhaps I can send the file in a message if someone has an idea on how to do this. I was trying all kinds of VLOOKUP, and IF formulas, but cannot get one that does what I need. Thanks in advance.


MASTER P/N QTY ord # p/n orders qty
554842 249 0004049376 69494R211 100.000
546361 636 0004046691 557034 11.000
514795-2 14 0004046779 537822 291.000
557928 10 0004048385 764329-2 16.000