I posted this in the Excel Workbook section, but I think it might nee
to be addressed in here as it appears to be more of a programmin
question, than an excel questoin.

Anyway here goes

I have a formula that returns a value in sheet1. Then I have a tabl
full of values, in the same workbook different sheet, that correspond
to that formula. I need to look up the value returned in sheet1 an
display the appropriate column/row where that value is located.

Example: value returned is 3.175
The table goes form 21 to 65 on both columns and rows.
3.175 is located at 37 column and 54 row, which is also cell locatio
R35. I need it to return the appropriate gears where B2:AT2 is Gear
and A2:A46 is Gear A.

Is it possible to do this?

If I can do the above, then I will work on the next part below, but i
it is possible to do both at the same time that would be even better.
So for the next part, the values in the table are not exactly sa
3.175, but might be 3.140 or 3.1764. So I guess I need to find a wa
to minimize the difference between all of them and take the cell wit
the smallest difference.

I might be getting in over my head, but it will make things a LO
easier if I can figure it out

--
Message posted from http://www.ExcelForum.com