Lisa wrote:
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
Excel's Intersection Operator (a space) is designed for this purpose.

Highlight your table and click Insert|Name|Create and check Top row,
Left column.

Then, e.g., =ProductA Vendor2 will return the corresponding price

Note that the product names and vendor names need to be in a form
acceptable for range names in a worksheet.

Alan Beban