Finding the "nearest" or "closest" number

[Edge]

Hi,

I have a colomn of metals each with a Youngs Modulus value beside it.

I have a calculation running from a tangent line on the graph
(extension vs force) that provides a value for youngs modulus.

What i want to to is... use the calculated value to match up the metal
which has the closest value to the one just calculated.

I was going to use IF but there are 23 metals and therefore the 7 IFs
are not enough.

any ideas,

thanks,

Miochael

 

[Edge]

i think i may be able to do it with a vlookup table, Ill have a go

 

[Ken Wright]

You can also use Index and Match depending on whether you wanted to be able to
get the smallest number that is higher than your target number, as opposed to
VLOOKUPs largest number that is smaller than your target number. You can often
tweak either to get round both though.