Referencing a Column containing both text and numbers

[Jay_Bang]

Hi. New here.

I have successfully referenced a column in a data table.

However, when I use that reference as a drop down in another table, it tells me the input is invalid. I assume this is due to the fact that the reference has numbers and text in it, which does not “compute”.

How do I make the ref table accept both numbers and text?

Thanks