Unsure of how to do this..

I have a workbook with 4 worksheets, sheet 1 blank for now, and the other 3 have pricing tables for 3 different vendors, 1 vendor per sheet.

What I want to do is In the black sheet, create 2 drop down menus in Cell A1 and Cell B1, one will be for color the other for size (know how to do this). Then I want in Cell C1 to tell me the price of this item in the picked size and color to be picked from the price table of the 3 I have. Don't know how to do this. Any help would be great.

Thanks,
Karleen

Karleen

What happens if 2 or more of the vendors stock relevant items?

Pick lowest / highest price?

rylo

the vendors do not caring the same Items, But if they would I would pick the item that cost less.

Hi

Being lazy and working on only 1 vendor match for the color / size combination try

=MAX(SUMPRODUCT(--(Sheet2!A2:A3=Sheet1!A1),--(Sheet2!B2:B3=Sheet1!B1),Sheet2!C2:C3),SUMPRODUCT(--(Sheet3!A2:A3=Sheet1!A1),--(Sheet3!B2:B3=Sheet1!B1),Sheet3!C2:C3),SUMPRODUCT(--(Sheet4!A2:A3=Sheet1!A1),--(Sheet4!B2:B3=Sheet1!B1),Sheet4!C2:C3))

adjust the ranges to suit.

rylo