Searching a table for a value that falls between two table cells.

[Ben Holland]

I have a table with ranges and an associated number for each range, table is names assetselection. I also have a table with a column showing the number of assets associated with a specific contract. I am attempting to search the assetselection table for the range that the specific number of assets falls within, and return the number of assets to be audited. Thanks for any help!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=XLOOKUP(I2,N2:N10,P2:P10,"",-1)

 

[Ben Holland]

Hi & welcome to MrExcel.
How about

=XLOOKUP(I2,N2:N10,P2:P10,"",-1)

Worked perfectly! thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.