|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
lookups and match
You're the best. Thanks so much!
"Toppers" wrote:
=INDEX($B$2:$D$3,MATCH(F1,$A$2:$A$3,0),MATCH(F2,$B $1:$D$1,0))
where F1 = Product
F2 = Vendor
$B$1:$D$1 are the vendors
$B$2:$D$3 are your prices
$A$2:$A$3 are the Products
HTH
"Don Guillett" wrote:
more details on your problem along with examples of what you tried.
--
Don Guillett
SalesAid Software
"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
|