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,""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return column header based on last value in row 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
match values in two column and return value in 3
Return Numeric Value to their Matched Value Position in Single Column 3
To return value that provide data to a formula 1
LOOKUP value in a table and return value in first column of same r 2
Lookup Value and Return Column Heading 6
Find value between range & return text 1

Top