Forum Discussion
paulj1
Helper II
8 years agoLOOKUPVALUE Nearest not exact
So i have a Table with column with 0, 2.5, 3.0, 3.5, 4.0, 4.5 I want to do a lookup value for nearest, in Excel id use VLOOKUP with the last parament True or False So Looking up; 1.12 wo...
Anonymous
8 years agoNot applicable
1.12 would return 0 ???
is this correct? or it should be 1