Mar 31 2022 05:33 AM
Hi,
I want to search between two values, and return a result. I have found this formula on multiple sites, but it isn't working for me.
=Lookup(2;1/((H9>=groeps!A3:A4)*(H9<=groeps!B3:B4));groeps!C3:C4)
H9 is my lookupvalue
A3:A4 minimum,
B3:B4 maximum
C3:C4 result
In my Excel version I need to use semicolon instead of comma, do I need something else for the * too?
Mar 31 2022 05:46 AM
It should work. Perhaps you need to confirm the formula with Ctrl+Shift+Enter.
Groeps sheet:
Sheet with formula: values between 11 and 30 return a valid result, others return #N/A.
(I use comma as list separator)
Mar 31 2022 05:58 AM