=LOOKUP(B1,{.1;.2;.3;.4},{102;101;100;99})

HTH,
Bernie
MS Excel MVP


"Mojo" wrote in message
...
I have 28 cells in a column with imported percentage (moisture) from a
database. I want to create another column that calculates maximum drying
temperature (for corn dryer) based on the percent moisture.

Example: If cell C2 = .10, max temp would be 105. If cell C2 = .34, max
temp would be 94, etc. Possible range of moisture percentage would be .10 to
.40. Max temp would go from 94 to 105.

I was able to figure this out in Excel 2007 easy enough using Lookup (lookup
(cell), {percent, percent, percent, "105","104","103"} etc. Struggling to
get Lookup to work like that in 2000.

HELP!