Forum Discussion
Solved
Return rows from a table based on a numeric value
I'm trying to filter tables based on a numeric value entered by a user. Here's what I'm trying to do: Hopefully that makes sense.
Try this one:
=LET( low, 1 * TEXTBEFORE(Table1[Range], "-"), high, 1 * TEXTAFTER(Table1[Range], "-"), FILTER(Table1, (input >= low) * (input <= high), "None found") )
Does the formula in the attached file return the intended result? I've made a simplification of the ranges 20 - 40 and so on in column B by separating them into 2 columns which is best practice in my opinion.
OliverScheurich Brilliant! Thank you so much. I hadn't considered putting the values in different columns, that makes sense.