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") )
Try this one:
=LET(
low, 1 * TEXTBEFORE(Table1[Range], "-"),
high, 1 * TEXTAFTER(Table1[Range], "-"),
FILTER(Table1, (input >= low) * (input <= high), "None found")
)