I am attaching the workbook I am having trouble with.RFQ TEMPLATE.xlsx

When an Item number is input into Cell A3, then a VLOOKUP finds the correct Part # and puts it in G3.

Currently in cell H3, the correct price is displayed based on the Qty in C3. However, currently this only works if the part # in G3 is found in the worksheet "PRICE". I need cell H3 to lookup the correct price in worksheet "CSP" if the part # in G3 is not found in worksheet "PRICE".

Not sure how to do this. I have searched and searched and cannot solve it. Any help is greatly appreciated!

thanks!