Adjusting numbers to nearest preferred number
 

I've a named and sorted range of integers (called 'ScalePts') - about 20 in
total.

I've a set of numbers in Column E (about 600).

In Column F, I'd like to put in the value from 'ScalePts' that is closest to
the column E value.

Can SKS help.

TIA

Rob

Adjusting numbers to nearest preferred number
 

Hi Rob,

Look he

http://www.cpearson.com/excel/TablesAndLookups.aspx

section Closest Match Lookup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BRob" wrote in message ...
| I've a named and sorted range of integers (called 'ScalePts') - about 20 in
| total.
|
| I've a set of numbers in Column E (about 600).
|
| In Column F, I'd like to put in the value from 'ScalePts' that is closest to
| the column E value.
|
| Can SKS help.
|
| TIA
|
| Rob
|
|
|