Dropdown list function

P

Pasty

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?
 
D

Debra Dalgleish

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.
 
Top