LookUp (These types can't be compared: Text, Numbers)

[vanhuxley24]

I'm trying to LookUp the value of what's entered in the text box. I wanted it to display the value from the excel database I have in the Label I created so that when they enter an EID, they would know it's correct because it shows the name.

However, my code doesn't work. See the image below.

 

[adgkred · Accepted solution]

 Hi @vanhuxley24,

You can use The Text() function to convert your number to a string of text. Once both types are set to text, your comparison should work. Should look like Text('Empd ID/New Kronos').

[vanhuxley24]

Thank you! 

I got it by doing this "LookUp(Database, Text('Emp ID/New Kronos') = Text(EIDEntry)).'Employee Name'"