This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Sheet 2
Column A - Zip codes
Row 2: 12345
Row 3: 12345-6789
Row 4: 23456
Row 5: 34567-8912
Column B - zip code helper column
Row 2: left(a2, 5) = 12345
Row 3: left(a3, 5) = 12345
Row 4: left(a4, 5) = 23456
Row 5: left(a5, 5) = 34567
Column C - index formula
Index(Sheet1!B:B, match(B2, Sheet1!A:A,0))
This formula is not working. Columns A and B are formatted as General, not Zip Code, or Zip Code +4, or Text. Any solutions?
Sheet 1
Column A - zip codes
Column B - county name
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
LEFT returns a text value, while column A on Sheet1 contains numbers. Change the formula in B2 on Sheet2 to
=--LEFT(A2,5)
and fill down.
Hi there
Question
Are the ZIP codes in Sheet1 column A in the same format as the helper column in Sheet2?
Regards
Jeovany