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

#### VivianLabon

##### New Member
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

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Weazel

##### Well-known Member
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

Replies
4
Views
78
Replies
3
Views
59
Replies
5
Views
46
Replies
5
Views
76
Replies
9
Views
78