wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
Hi all,
I am trying to use XLOOKUP with 2 criteria to return an approximate match (Match Mode = -1)
I believe the formula below should return 1 at 0.6, but as you see, it is returning 1 at both 0.8 and 1 (Selected).
Any idea why that would be and the correct fix?
Thanks,
-w
I am trying to use XLOOKUP with 2 criteria to return an approximate match (Match Mode = -1)
I believe the formula below should return 1 at 0.6, but as you see, it is returning 1 at both 0.8 and 1 (Selected).
Any idea why that would be and the correct fix?
Thanks,
-w
Resp | Rand | Value |
1 | 0.797367 | 1 |
2 | 0.717577 | 1 |
Formula: |
=XLOOKUP(E3:E7,IF(tblData[Resp]=C3,tblData[Rand]),tblData[Value],0,-1) |