Can you please help to get correct Vlookup function.

I have two huge Worksheet which has 45000 lines on each sheet. I want to
look up one value in both the sheet. If look value in not found in Sheet1
then go to Sheet2 & get the out from there.

Please let me know if this is clear to you.