Vlookup & Concatenate

Hello

I want to Vlook a value from a cell in another workbook then before I get the formula result I would like it to concatenate the result with another cell - I assume this is possible but would appreciate some assistance - I have attached an example

Thanks

AlEXAMPLE.xls