I am pretty sure I need to use MATCH but can't quite get it working.
For Example
Sheet1
a
b
c
d
Sheet2
a 1
d 4
Desired sheet1
a 1
b (blank/empty)
c (blank/empty)
d 4
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI am pretty sure I need to use MATCH but can't quite get it working.
For Example
Sheet1
a
b
c
d
Sheet2
a 1
d 4
Desired sheet1
a 1
b (blank/empty)
c (blank/empty)
d 4
Assuming it is not the text (blank/empty)
that you want but rather a seemingly empty cell and that a
in both sheets is in cell A1, please try in Sheet1 B1:
=iferror(vlookup(A1,Sheet2!A$1:B$4,2,0),"")
and copy down to suit. VLOOKUP
IFERROR
tests the result of the lookup function (which will return an error where the sought value is not found) and returns a 'blank' with ""
.
Vlookup was the way to go here is the final version:
=IFERROR(vlookup(A1,Sheet2!A$1:B,2,false),"")