Hi there, i'm new, sorry for my bad English...
My problem is this:
I would like to write a formula to have a result in a cell that gives me the maximum value of a column, but smaller than another cell.

For example:
C1 = Maximum value in column A1:A20, but smaller than B1.

Thank you in advance for the help, i hope you understand my question.