Hi,

I have a filter that contains 12 ranges of 2 columns (on one sheet). Each
one of those ranges I've given the specific name.
The filter (each range) includes number of days (ascending) and the score
(evaluation) for that number of days (actually it's a duration). OK...
At the other sheet there is a table with the data about the customer's
complaints and among that data there are records identical to those names
I've defined for mentioned ranges at the sheet before. In the table data
there is a duration, and for that value I wan't to show the score depending
it's match in the filter.
Or simple: Can I lookup the value within a range (name defined), if that
"name" is shown in a cell next to the value? Actually, the data in that cell
is not a name, it's a value with the same name as the name I've defined for
the specific range.
Is this explanation reasonable?

Thank you all in advance!

Kruno, Croatia