Originally Posted by Mazzaropi

----------------------------------------------------------------------

Dear mdawn, Good Evening.

I did an example for you.
It´s here : 16-02-2011_ExcelBanter_Search_for_MDAWN_V1-0.xls

ATTENTION:
As you are looking for a specific number, if at a table there are repetitive numbers your answer will be the first gear setting number that the formula finds.
The search occurs left to right and top to down.

I used Conditional Formatting to show the value at a table.
Just as a appearance complement.

Look at the number 3 at the example.


Tell me if it worked for you.