Test many records against many conditions that are in other records

I have 2 worksheets with dates. The first dataset describes 100 different categories with fields such as length (from and to), width (from and to), height (from and to), weight (from and to), color and material.

The 2nd dataset describes objects with properties as they appear in the categories in the first dataset.
Which formula should I use to investigate for each record in the 2nd dataset (the objects) in which category from the first dataset this object falls?

LaFormula I understand that your other thread is in Dutch, but you are only allowed 1 thread per question. Seeing as this seems to be progressing, I will close your other thread, you may continue here.
https://www.excelforum.com/non-engli...e-records.html

Here are 2 different solutions:

Please try in O5 and copy down:

Formula:

Please Login or Register  to view this content.

or everthing in one go, please empty all expected results and try in O5 (no copy down needed):

Formula:

Please Login or Register  to view this content.

With that formula, you can change the 1 to TRUE, or put a double unary in front like:

=XLOOKUP(TRUE,(B2=H$2:H$20),G$2:G$20,"-")
=XLOOKUP(1,--(B2=H$2:H$20),G$2:G$20,"-")

(Note: this is because you are only using one comparison, the compare brings back TRUE or FALSE. Once you multiply it (doing more than one comparison) it changes true false to 1 and 0)