Formula help for choosing from a set of values

C

ccclwilson

I am looking for help for a formula that will look at a set of values in
three columns and return the value of the last cell with data. Example
below. Hope this is not too vague.

col1 col2 col3 Result
1 1
1 2 2
1 3 3

If col1=1, return 1
If col1=1 and col2=2, return 2
If col1=1, col2=0 and col3=3, return 3
 
T

T. Valko

To return the *last numeric* value from a range:

=IF(COUNT(A1:C1),LOOKUP(1E100,A1:C1),"")

Copy down as needed.
 
C

ccclwilson

Wonderful, it works. Thanks.

T. Valko said:
To return the *last numeric* value from a range:

=IF(COUNT(A1:C1),LOOKUP(1E100,A1:C1),"")

Copy down as needed.
 

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

Top