jase71ds
Board Regular
- Joined
- Oct 23, 2006
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
I'm trying to use XLOOKUP to reference a single cell (array) and return a value.
Example
A1 = .6
B1 = {0, .1, .6, .9, 1}
XLOOKUP( A1, B1, B1, , , -1 )
So if A1 were .6, then .6 would be returned
But if A1 were .5, then .1 would be returned
I understand that I could take cell B1 and stretch it out from B1 to B5, but I'm wondering if XLOOKUP can work with a single cell array.
Anyway, I've had no luck getting XLOOKUP to work with a single cell array. Am I doing something wrong, or is this just not possible?
Thanks.
Example
A1 = .6
B1 = {0, .1, .6, .9, 1}
XLOOKUP( A1, B1, B1, , , -1 )
So if A1 were .6, then .6 would be returned
But if A1 were .5, then .1 would be returned
I understand that I could take cell B1 and stretch it out from B1 to B5, but I'm wondering if XLOOKUP can work with a single cell array.
Anyway, I've had no luck getting XLOOKUP to work with a single cell array. Am I doing something wrong, or is this just not possible?
Thanks.