Google-sheets – Compare two lists and pull values from a 3rd column based on where match was found

google sheets

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

Best Answer

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 "".

Related Solutions

Google-sheets – How to specify “everything except the top row” as a range

There's an easy way. For example, for a sum, you can specify it like this:

=SUM(G2:G)

So basically, specify the first cell you want, then the name of the column. That way, you can skip as many rows as you want.

Google-sheets – How get last added text from column into different sheet

This formula works perfect:

=IFERROR(INDEX(FILTER(Sheet1!A:A,Sheet1!A:A<>""),
         COUNTA(FILTER(Sheet1!A:A,Sheet1!A:A<>""))))

(found the answer somewhere else)

Best Answer

Related Solutions

Google-sheets – How to specify “everything except the top row” as a range

Google-sheets – How get last added text from column into different sheet

Related Topic