Forum Discussion
Look up between less than or equal to HELP
Hey there people, This may be a very simple array or LOOKUP formula but my brain doesn't work like it used to. If you look at the table above, I am setting up a spreadsheet to look up a figur...
MrShady You will need nested XLOOKUP() with Exact match or next larger item parameter. Try
=XLOOKUP(D8,B2:B4,XLOOKUP(D7,C1:L1,C2:L4,0,1),0,1)
Nested FILTER() function will also work. See the attached file.
=TAKE(FILTER(FILTER(C2:L4,C1:L1>=D7),B2:B4>=D8),1,1)
NAILED IT!! Thank you so so much, you're a legend!! 🙂