Pulling additional information after Vlookup

What I have:

I have 2 sheets. On Sheet 1, I have a list of 20 numbers (in column A) that I need to pull data for. On Sheet 2, I have a large quantity of data.
I ran a VLookUp function (Sheet1, column B) to determine if any of my 20 numbers exist in column A of sheet 2.

Excel.JPG

What I need:

If my VlookUp function returned a matching value; I want column C on sheet 1 to display the value of Column B, sheet 2, that corresponds to it.

Attached is a very very simplified file of what I have.

I am open to different ways of approaching this problem. Thank you in advance for any assistance!

Welcome to the board!

Try,

=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"")

where A2 could be replaced with B2 given your current structure. Not sure why you have a column B in Sheet1.