Formula VLOOKUP I think
I have a set of numbers in column AG.
0.3411
0.5423
0.3310
0.9062
1.2282
0.8350
0.7205
0.8818
0.6557
0.6424
0.5358
0.4751
0.4319
0.3756
0.3713
0.3413 Formula here is in cell AK5207
I am playing with VLOOKUP to try and find the closest number from the
list which matches cell AG5207 which is 0.3413
|