On Google Sheets how to associate a value between two sheets based on the common id match?

On Google Sheets I have a spreadsheet with a first Sheet containing two columns that have id and price like this

id price
000050009 1
934737483 3

And then I have a second Sheet with columns containing id and title like this

id title
934737483 Title alpha
123456789 Title beta!

How to associate the title contained only in second Sheet, into a new column of the first Sheet based on id Match?

>Solution :

Sheet2:

enter image description here

Formula:

=arrayformula(ifna(vlookup(A2:A, Sheet2!A2:B, 2, false), ""))

enter image description here

Leave a Reply