Vlookup

[Biffarama]

In my worksheet I'm trying to fill in the Zip Code column based on the City and State listed for each row. I downloaded a zip code database and added it to my worksheets a new tab in the hopes that I'd be able to use the VLOOKUP formula to populate the field from it, but I can't seem to figure it out. Looking for any help I can get with it.

Let me know if you have any questions or I haven't been clear.

Thanks in advance for your help.

Troy

 

[Nine Zero]

Re: Need help with VLOOKUP

OOOOhhhh I see initially you mentioned you had two seperate workbooks but you actually have onlye 1 workbook with 2 seperate sheets....even better!

=VLOOKUP(CONCATENATE(C2,D2),'free-zipcode-database-Primary'!$D:$E,2,0))

Try this out

 

[Biffarama]

Re: Need help with VLOOKUP

My mistake for not being clearer about that, but the formula above worked great, thank you so much!