How to return value from last column w/value?

B

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
+-------------------------------------------------------------------
 
A

Aladin Akyurek

bimmerman said:
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!!
Click to expand...

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

Row 2 will cause #N/A
 
A

anilsolipuram

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


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