Valid If dropdown doesn't show option containing alphabet

Shyang
New Member

Hi there, while I was creating a valid if dropdown list, the numerical options (e.g. 123) were shown, however for any cell containing alphabet, such as “abc” or “EL000180333LA”, these were excluded.

Can anyone please guide me on how to resolve this issue by having all cells to be included in the dropdown list?

0 5 116
5 REPLIES 5
Top Labels in this Space