title: Organize excel columns together
body: <p>I have three excel spreadsheets and I don't how to do anything with excel. I need to find a way to associate IDs from one column to another column.</p>
  <p>I have a column called &quot;Display Name&quot; and I have 2 columns in another worksheet called &quot;IDs&quot; and &quot;Display name&quot;.</p>
  <p>I want to compare the &quot;Display names&quot; from the first spreadsheet to the &quot;Display names&quot; on the second spreadsheet. I then I want to pull all the ids and match them based on there name. I have over 1000 and don't want to do this manually.</p>
  <p>I copied the IDs to the first worksheet. Here is a picture of what I am trying to do:
  <a href="https://i.stack.imgur.com/NR9Lt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NR9Lt.png" alt="enter image description here" /></a></p>
  <p>Any ideas or links to help me get started would be awesome. I literally don't know anything about excel. I tried vlookups but I kept getting either a name error or a ref error.</p>
  <p>Thanks for your time,</p>