Returning number from different sheet with VLOOKUP

Hi,

I'm stuck on retrieving col_index_num from another sheet. With table_array everything is ok, it looks in Sheet2, but I can't seem to take column from Sheet2, it always takes it from Sheet1).
Formula is in Sheet1:
=VLOOKUP(A1; Sheet2!B1:B114; 1; FALSE)

I want to take 1st column value where it finds that match from Sheet2

Thanks for your advice.