Help with matching function

[Khaldon]

I would like please the formulas in cells N3 and P3 from the attached sample sheet to be modified as follows:

If an exact match manual entry value in cell M3 with A31:A85, cells N3 and P3 to return the exact match from A31:A85.

If no exact match manual entry in cell M3 with A31:A85, cells N3 and P3 to return next higher match from A31:A85 column.

[oeldere]

You work with merged cells.

The advice is don't work with merged cells, you get in trouble with it, sooner or later.

You don't have any values in the sheet.

You don't have the desired result in your sheet.

In that case it is difficult to test the formula.

[Khaldon]

A new sheet is attached with sample values on it.

Example, if I enter the value (14) in cell M3, I would like please the formula in cell N3 to return (268.5). And if I enter (15) instead of (14) in the same cell M3 I would like the same new edited formula in cell N3 to return (268.3).

[benishiryo]

hi Khaldon, try:
=IF($M$3="","",INDEX(C8:C62,MATCH(TRUE,INDEX(A8:A62>=M3,),0)))

colouring all the cells in Excel is not a good idea by the way. takes up resources

[Khaldon]

That dose it, thank you for the colouring advice.