Finding nearest value in a lookup table
Finding nearest value in a lookup table
(OP)
I have an Excel spreadsheet that calculates a series of resistor values from some test data. The problem I have is that I want the spreadsheet to select the nearest available values of resistance from a table of preferred values, a common enough type of problem I would have thought.
Is there an Excel function that will do this or is it time I got to grips with Visual Basic?
Thank you
Peter
Is there an Excel function that will do this or is it time I got to grips with Visual Basic?
Thank you
Peter





RE: Finding nearest value in a lookup table
http://www.ozgrid.com/download/default.htm
perhaps ones of the many examples will meet your needs. pls advise of any needed information.
good luck!
-pmover
RE: Finding nearest value in a lookup table
RE: Finding nearest value in a lookup table
RE: Finding nearest value in a lookup table
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Finding nearest value in a lookup table
I've got two columns of preferred values, one ascending the other descending, and a MATCH function for each, then an IF statement to get the closest value.
As electricpete says (Pete, in cricket terms, you're an all-rounder!) I have to use an INDEX function with each MATCH function as the latter gives a cell reference rather than the actual value.