How to return value from last column w/value?

[bimmerman]

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

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

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

THANKS!

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

 

[Aladin Akyurek]

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

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

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

THANKS!!

=LOOKUP(REPT("z",255),A11)

Row 2 will cause #N/A

 

[anilsolipuram]

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


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