Dropdown list function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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