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.