Drop down or lookup table help

[karleen77]

I have no idea of how to do want I want.

I have a workbook with 2 sheets. Sheet 1 is name quote and sheet 2 is named vendor price.

SO vendor price is a table Column A is a list of items the vendors colors and Row 1 is all the sizes, and the rest of the cells has the pricing to match each size and color.

Then on sheet quote I made drop down list in A1 and B1. A1 has Color and B1 and Size, now in C1 I want it to automatically show the price that would be in the matching cell on the table I used to create the drop down lists.

I have attached the the for you to look at too - maybe that will help.

I just don't know how to get A1 + B1 to look up the matching cell.

Any help would be great!

Thanks,
Karleen

[Ron Coderre]

I'm not a big fan of opening posted files....so I used this example:

On the Vendor_Quote sheet, cells A1:D6 contain:

(blank)__Large____Medium__Small
Red_____15______10______5
Orange__14______9_______4
Yellow___13______8_______3
Green____12______7_______2
Blue_____11______6_______1

And...on the Quote sheet:

A1: (a color....eg Red)
B1: (a size.....eg Large)

Option_1:
C1: =VLOOKUP(quote!A1,Vendor_Price!$A$1:$D$6,MATCH(quote!B1,Vendor_Price!$A$1:$D$1,0),0)

or...Option_2:
C1: =INDEX(Vendor_Price!$A$1:$D$6,MATCH(quote!A1,Vendor_Price!$A$1:$A$6,0),MATCH(quote!B1,Vendor_Price!$A$1:$D$1,0))

Note: Neither of those formulas contain spaces.

In my example, C1 returns 15

Is that something you can work with?