This formula works in my working out spreadsheet

=IF($I$33=$J$33,$L$26:$L$27,)

but if I do the same in the register I am using it gives me the message

"the list source must be a delimited list, or a reference to a single row or
column"

Would anyone know why this is?

You could create a second range and use it when I33<J33. Change the
formula to include it, e.g.:

=IF($I$33=$J$33,$L$26:$L$27,$N$27)

The second range ($N$27) could contain a single cell with a zero or N/A.

Pasty wrote:
This formula works in my working out spreadsheet

=IF($I$33=$J$33,$L$26:$L$27,)

but if I do the same in the register I am using it gives me the message

"the list source must be a delimited list, or a reference to a single row or
column"

Would anyone know why this is?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html