Lisa,

Assuming that your product names are in column A starting in row
2, and vendor numbers are in row 1, use a formula like

=OFFSET(A1,MATCH("a",A2:A10,0),MATCH(2,B1:D1,0))

This will look up product "a" and vendor 2.

See the Double Lookups section at
www.cpearson.com/excel/lookups.htm for more details on various
techniques to look up data in tables.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Lisa" wrote in message
...
Hi. I'm trying to do a lookup in a table; however, I'm stuck. I
tried doing a
match and index, but I can't get it to work.

IE... For Product A, Vendor 2 would charge ____? And so forth.

Vendor
Product 1 2 3
A $5 $7 $9
B $8 $7 $6

Thanks so much,
Lisa