Lookup function?

[helens0]

Apologies, my initial posting seems to have failed.

I am looking to find a formula that will return the highest value from a list that is lower than another value which is specified in a different cell.

e.g

Find the highest number in the list below that is greater than a number in (eg) cell A1 : 60

57.576

57.778

58.113

58.261

58.364

58.371

58.389

58.636

60.000

60.082

60.140

61.189

Any help greatly appreciated.

Many thanks

Helen

[ootsoo]

hi helen,

Assuming the numbers [57.576......61.189] are put in C3:C15 and number 60 in A1

execute this formulae

IF((MAX(C3:C15)>A1),MAX(C3:C15),A1)

in cell C16(say)

hope this solves ur problem...

regards,

Ootsoo