I am using the below function to return the last data value populated in the
range B57:AE57.

=IF(COUNT(B57:AE57),LOOKUP(99^99,B57:AE57),"-") ---- this works for a single
line of data

I want to be able to include multiple ranges in the look-up. Specifically,
I want to be able to include B64:AE64 in the look-up. I wrote it as follows
and it returned the N/A error message. Please, what am I doing wrong?
=IF(COUNT(B57:AE57,B64:AE64),LOOKUP(99^99,B57:AE57 ,B64:AE64),"-")----this
doesn't work for 2 lines of data


Thanks - Tom



--
Sony Luvy