Searching for a value in an Array
=INDEX(C1:C100,MATCH(1,(A1:A100="country")*(B1:B10 0="machine"),0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Farah" wrote in message
...
I have a master price list were I have in column A the country name, and
in
column B the machine model number and in column C the price.
Obviously you can find the same machine for many countries with different
prices, I need a formula were I can extract for a certain country the
price
of a certain machine.
|