View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_] rhhince[_2_] is offline
external usenet poster
 
Posts: 48
Default 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