Vlookup between sheets - If cell matches cell in range, copy adjacent cell - Range on different sheet

[VivianLabon]

I'm using the below formula to use a Vlookup to copy from an adjacent cell, out of the range B3:C20

=IFERROR(VLOOKUP(A3,$B$3:$C$20,2,0),"")

I am wondering what the formula would be to pull the number from a different sheet, within the same workbook.

Specifically i'm working with:
Cell (A3) which I want to match to a range - B3:B20. If there is a match, I want the adjacent cell in row C to be copied to the formula cell.
So if A3 matches B4, C4 would be displayed.

However: the range B3:C20 is in Sheet 2

Thank you

 

[Weazel]

something like...?

=VLOOKUP(A3,Sheet2!$B$3:$C$20,2,0) or

=VLOOKUP(A3,'Sheet 2'!$B$3:$C$20,2,0) if there is a space between sheet and 2