displaying estimates based on a table with limited data

hi, I was wondering how to do this:


let's say I have a table of values in sheet 2:
108
110.5
113
115.5

then in sheet 1:
I enter the number 109 in column A1, and I want excel to show me in the cell beside it what value it is closest to based on the values in the table in sheet 2.

Originally Posted by MarvinP

Hi Robert99,

Look at the VLookup function in Excel and the last parameter/argument called Range Lookup. This one tells if it needs an exact match (to your 109) or not. Read the examples on http://msdn.microsoft.com/en-us/library/dd797422.aspx

thanks! Problem solved!