On Thursday, July 19, 2012 9:45:01 AM UTC-4, Claus Busch wrote:
Hi,

Am Thu, 19 Jul 2012 06:35:50 -0700 (PDT) schrieb :

> I have the following formula that currently works in my spreadsheet where I have a row of #'s that I need to return the one to the furthest right (new #'s get inserted into the range on a regular basis). The formula is =LOOKUP(9^99,46:46).
>
> I now need to flip the formula so that it returns the # furthest to the left in row 46.

try:
=INDEX(46:46,MATCH(TRUE,ISNUMBER(46:46),0))
and enter with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

I get "false" with this formula. When I hit CTRL+Shift+Enter it enters a "{" infront of the "=". Thoughts?