Vlookup

[Sadie]

Hi-
Is there any way to have VLOOKUP return the next highest number, whe
no exact match is found? I need to be able to access both the lower
higher values for an entered temperature, so that I can interpolate th
result! Please help

 

[Frank Kabel]

Hi
a little bit kludgy but it should work:
Assumptions:
- your lookup list in in columns A:B (column B stores the value to be
retunred, col. A the lookup values)
- the data is sorted by A in ascending order
- The lookup criteria is in C1

Try the following
IF(ISNA(MATCH(C1,A1:A100,0)),INDEX(B1:B100,MATCH(C1,A1:A100)+1),VLOOKUP
(C1,A1:B100,2,0))