TransWikia.com

How to merge and combine 2 spreadsheets in Google Sheets or Libre Calc, both sheets have matching ID numbers

Super User Asked by mcgendraft on October 10, 2020

I have 2 spreadsheets, each one has an ID number that is the same, I am looking to add the info from one to another. I would like to take the information from spreadsheet A which is an ID number, and a description (ex. 652 | Red Sweatshirt and merge into spreadsheet B, which has the same ID number, but missing the description that is in spreadsheet A (ex. 652 | $4.99 ) so the end result would be (652 | $4.99 | Red Sweatshirt ) Would I merge, consolidate, or Vlookup? I am not good with spreadsheets at all, so if its a formula, a short example would be awesome!I only have Libre Calc or Google Sheets, so any of those 2 program examples would be preferred.
Thank you in advanced.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP