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?
CodePudding user response：
Sheet2:
Formula:
=arrayformula(ifna(vlookup(A2:A, Sheet2!A2:B, 2, false), ""))
