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?

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

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With