INDEX and MATCH with range
No, it is not the MATCH that is an AND, it is the * that acts like AND, and
your original formula already had one.
--
HTH
Bob
"oliver.bradley" wrote in message
...
On Mar 29, 9:44 pm, "Bob Phillips" wrote:
Try
=INDEX('Price data'!$I$2:$I$29,
MATCH(1,('Price data'!$A$2:$A29=InputProduct)*
('Price data'!$F$2:$F$29<InputNumber)*
('Price data'!$G$2:$G$29InputNumber)*
('Price data'!$H$2:$H$29=InputCurrency),1))
--
HTH
Bob
Duh! Of course the Match is an AND already. Thank you so much - I
would have stared at that for days.
|