When using the VLOOKUP or CONCATENATE functions, after entering all the
necessary parameters, the result of the function is the function equation
itself. For instance, here is what my VLOOKUP function is returning for a
value :=VLOOKUP(C2,'[Material Class BO Download.xls]Material Class BO
Download'!$A$2:$B$895,2,false)

I have used the VLOOKUP function before so I know it's not an issue with
equation, it has something to do with how the cell is formatted because I can
do the VLOOKUP successfully in another column, but then I have to copy/paste
the results into my intended column