Forum Discussion

MrShady's avatar
MrShady
Copper Contributor
Jul 01, 2024

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...
excel
Formulas and Functions
office 365
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jul 01, 2024

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)

 

 

 

Resources