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