Let's say I have 4 columns, how do I go about returning the right most
value?

As you can see, the right most value could be in any cell in the
range.

So for row 1, I'd like to return 'fail', row 2 would be blank, row 3
would be start.

THANKS!!


+-------------------------------------------------------------------+
|Filename: excel_help.gif |
|Download: http://www.excelforum.com/attachment.php?postid=2800 |
+-------------------------------------------------------------------+

--
bimmerman
------------------------------------------------------------------------
bimmerman's Profile: http://www.excelforum.com/member.php...fo&userid=2623
View this thread: http://www.excelforum.com/showthread...hreadid=319534

bimmerman Wrote:
Let's say I have 4 columns, how do I go about returning the right most
value?

As you can see, the right most value could be in any cell in the
range.

So for row 1, I'd like to return 'fail', row 2 would be blank, row 3
would be start.

THANKS!!

=LOOKUP(REPT("z",255),A1:D1)

Row 2 will cause #N/A.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319534

try this formula at e1,select e1 cell and drag it down.


=IF(D1<"",D1,IF(C1<"",C1,IF(B1<"",B1,"")))


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=319534