•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find nearest value like LOOKUP?
Is there a way to find the nearest value (number) to a given value? For instance I’m trying to find the closest value to 12345 and the reference table has 12340 and 12346, it would return 12346 as the closest value. Not putting this very eloquently, hope it makes sense. Thanks.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#nearest value
#lookup
#closest value
#reference table
#find nearest value
#given value
#number
#value
#excel
#find
#12340
#12345
#12346
#comparison