One thing that I forgot to mention in my earlier Post is that once it
does a match on the part#, it needs to lookup the qty and bring back
the price that is closest to the qty. Using the example from before.
If I have a Part# of 1, qty of 7 (there is not listed qty of 7) then
it needs to give me the price of 50 (which would be the 5 qty). That
is how the vlookup works and that is what I really needed.
Thanks again.. sorry I forgot that "minor" detail
Chris

Part# qty price
1 2 20
1 5 50
1 10 100
1 20 200
1 30 300
1 50 500
2 2 20
2 5 50
2 10 100
2 20 200
2 30 300
2 50 500