Lookup value in table and return position

[VonnerNIX]

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

EX: 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 location
R35.

Is it possible to do this? It would be a great help. Thank you.

 

[VonnerNIX]

Unfortunately there is one more thing, that I might be able to ge
around later, but maybe not. The values in the table are not exactl
say 3.175, but might be 3.140 or 3.1764. I'm assuming I will have t
write some VBA code to get this to work, but didn't know if a loopin
lookup could return something close