I am trying to create a formula that searches for text in a column and
returns a matching number based on the text that is entered in that cell.

A portion of the formula that I created is below where my real list is 19
rows long, which is why I can't use the IF formula.

=LOOKUP(D13,{EUE,NUE,STC,LTC},{"0150","0151","0152 ","0153"})

When I enter this formula and check the function, the LOOKUP_Vector reads
"Invalid".

I have used the same formula with success in the same workbook, but the
look-up vector is numbers instead of text.

Any suggestions?