How to return value from last column w/value?

  • Thread starter Thread starter bimmerman
  • Start date Start date
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
+-------------------------------------------------------------------
 
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
 
try this formula at e1,select e1 cell and drag it down.


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