Search for a number in another sheet and replace with a different column name

I have multiple sheets in an excel file. Sheet1 has multiple columns, first column is barcode(for eg. 5463577263). I want to find this barcode in sheet2 and grab required fields using vlookup.   Th...