Hi,

I have 2 worksheets.

When I type 150 in worksheet #1, I want excell to lookup the value from
worksheet #2 that correspond to 150 (and return those values in Worksheet
#1). Since there is no 150 (in worksheet #2), I want it to give the
corresponding value in column B and C by averaging (In this case the answer
needs to be 15 and 47.5 respectively in column B and C) or if I enter 175
then it should give me 17.5 and 53.75.

Thanks very much for your help.

Worksheet #2

100 10 30
200 20 60
300 30 90