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

VivianLabon

New Member
Joined
Jul 17, 2014
Messages
5
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
 

Some videos you may like

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
Joined
Dec 24, 2011
Messages
3,155
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,922
Messages
5,525,645
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top