title: How can I use MATCH() with differently catagorized data?
body: <p>I have a spreadsheet <code>A</code> which contains a list of departments. One cell contains the department ID 76560 with the data type set to <strong>Text</strong>. (<em>Format Cells → Number → Text</em>)</p>
  
  <p>Spreadsheet <code>B</code> contains detailed information about department 76560 I want to reference from spreadsheet <code>A</code>. However, spreadsheet <code>B</code> has the department ID's data type set to <strong>General</strong>.</p>
  
  <p>I want to use <a href="https://superuser.com/a/1228559/358766">INDEX/MATCH</a> to match up the department ID's, but unfortunately MATCH only seems to work the department ID is formatted as text in both documents.</p>
  
  <p><strong>To summarize:</strong></p>
  
  <ul>
  <li>Spreadsheet <code>A</code> stores the ID number using the <strong>Text</strong> data type.</li>
  <li>Spreadsheet <code>B</code> stores the ID number using the <strong>General</strong> data type.</li>
  <li><code>MATCH()</code> only works if the data types are identical.</li>
  </ul>
  
  <p><strong>If two spreadsheets are storing the same ID using two different data types, is there a way I can still match up information between the two spreadsheets?</strong></p>