Vlookup to extract last five characters or include only first 5 characters

[Michael Lerena]

Hello. New to excel.

I have two spreadsheets. I am performing a vlookup, =VLOOKUP(A2,'REAMSView-UtilityActivated-RawD'!$B:$G,6,FALSE) which works fine. So it pulls the zip code 35020-0000 from another tab. However, i want to exclude the last 5 characters, so that the vlookup only inputs the 5 digit zip code, 35020.

Please help, I have tried many combinations and nothing is working. I am using office 365, if that is relevant.

[Raphaelp]

Try:

=LEFT(VLOOKUP(A2,'REAMSView-UtilityActivated-RawD'!$B:$G,6,FALSE),5)

[Michael Lerena]

You did it!!!