A VLOOKUP will give you what you want. With a little algebra, you can
also interpolate the results, if that is necessary.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I wish to calculate the accuracy and precision of laboratory pipettes,
and use the specific gravity of water. However, the specific gravity
of water changes with temperature and this needs to be included in the
equation. I would like to have box in the spreadsheet for the
temperature. I would then like to relate this value to some
pre-determined constants = eg at 22oC specific gravity = 0.9978, at
23oC specific gravity equals 0.9976 etc. Therefore, the calculation
would need to check what value of temperature is entered,
cross-reference the specific gravity value and then use the value in
the equation.

can anyone help?