Index/Match for a number in a range

[zzer0]

Hello,

I'd like to do a multiple criteria lookup to find the cost per unit of a book. I'd normally use Index and match to do this but I'm having trouble because one of my lookups is not exact and is in a range.

I tried doing boolean logic with an xlookup, but I can't get it to work unless the page count is exactly what the table lists.

Any help is greatly appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(FILTER(J3:J200,(G3:G200=N2)*(I3:I200>N3)),1)

 

[zzer0]

Hi & welcome to MrExcel.
How about

=TAKE(FILTER(J3:J200,(G3:G200=N2)*(I3:I200>N3)),1)

Wow! You are fast and it works! I have never used take or filter so thanks for adding it to my repertoire.

Cheer!

 

[Fluff]

You're welcome & thanks for the feedback.