Do I Iuse Multiple VLookup or If formula

[jschoon4]

I have 4 columns (A: Cat#,B: Member#,C: Vendor#, D: Price) on Sheet1. Columns A thru C on Sheet 1 has a different number in Rows 2 thru 10 and Column D is blank to enter the VLookup formula. On Sheet 2 I have 2 Columns (A: Cat#, B: Price). Column A: has several rows with numbers and Column B: has several rows with pricing.

How can I use Vlookup in column D on sheet1 to look at Columns A thru C on sheet 1 and pull the price over for that number from sheet 2 to Sheet 1? But remember I'm trying to pull over the price for either A: Cat#,B: Member#,C: Vendor#. One or more of the numbers in Columns A thru C will match Column A on Sheet 2

 

[BobUmlas]

in D2:

=IFERROR(VLOOKUP(A2,Sheet2!$A$1:$B$3,2,FALSE),IFERROR(VLOOKUP(B2,Sheet2!$A$1:$B$3,2,FALSE),IFERROR(VLOOKUP(C2,Sheet2!$A$1:$B$3,2,FALSE),"")))
and fill down

 

[jschoon4]

Thank you