second to last in row

[taino8632]

I am using the following formula to determine the second to last numeric value in a row.

=LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1))

However, in cases where there is only one value in the row I am getting an #N/A error. How do I account for this error? I want to return a blank if there is only one value in the row.

Thanks for your help.

 

[lenze]

IF(COUNT($C2:$BB2)=1,"",LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1))

lenze

 

[jasonb75]

In excel 07 or 10

=IFERROR(LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1)),"")

In 03 or older

=IF(ISNA(LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1))),"",LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1)))

 

[prabby25101981]

You can make use of the ISERROR() function.

 

[taino8632]

Many thanks to all. Both options work quite well.