On Thursday, July 19, 2012 9:49:27 AM UTC-4, (unknown) wrote:
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?



I'm sorry, I left out that the data in Columns A-F will not change This formula is getting put in D43 and the range starts in G and goes all the way right.