I hadn't seen that post when I posted again. I'm about to try it. Keep your
pants on.

"Ron Rosenfeld" wrote:

On Thu, 17 May 2007 11:06:00 -0700, Jamie
wrote:

OK - I apologize - the example I gave you was just an example and not exactly
what I need. I tried to follow your formula as a template for my specific
need and had trouble, Let me explain exactly what my situation is:
Scenario: Sheet 2, Cell B50= Change0.320
I want: Sheet 1, Cell C27 to = 0.320
Worksheet B, Cell D27 to = Change


And what was the problem with RagDyer's suggestion?

=LOOKUP(99^99,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},
A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2)))))


--ron