Finding values closest to a certain number then returning th

[lars92RS]

I have 3 columns of data. I want Excel to find the value that is closest to a specified value then display that row in another sheet. For example I want to find the value closest to 65 and I have 64.8 and 65.4, i want excel to pick the row with 64.8 and then put that row of data in another table I specify. I'm looking for VBA code for the most part. Thanks to all!!!

-Lars
This message was edited by lars92RS on 2002-02-28 09:06

 

[lars92RS]

ttt