VBA - VLookup in another sheet with fixed table_array

Hi guys, I do have a rather simple problem that probably just causes me trouble do to syntax errors.    I want to VLOOKUP a cell in a row in a fixed table_array in another sheet. Later, my script ...