format formula to read as text only

Hello,
I am using a CONCATENATE formula to designate an ID number taken from multiple cells.
=CONCATENATE(LEFTB(F2,2), LEFTB(E2,1), LEFTB(B2,3))
Based on the result of that formula i have another sheet where i am using a LOOKUP formula so that when i type in the result of my concatenate formula on the previous page it will fill in information on the current sheet.
=LOOKUP(F5,[NYSTAPWATCH.xlsx]Sheet1!$C$2:$C$33,[NYSTAPWATCH.xlsx]Sheet1!$B$2:$B$33)
my formulas work for some of the ID numbers but others put in incorrect information. I am thinking its because excel isn't designating the results of the first formula as a text, rather a formula. I tried hiding and locking the formula but had the same results. Is there something i can add to my formula to designate to read as text?

Try instead:

=INDEX([NYSTAPWATCH.xlsx]Sheet1!$B$2:$B$33,MATCH(F5,[NYSTAPWATCH.xlsx]Sheet1!$C$2:$C$33,0))

Lookup needs the column C values to be in ascending sorted order.