Auto Populate Cells based on Matching Range Text

[bhamm]

Hello

I'm working in Excel 2007 on Windows 7.

On Sheet 3, I have a list of towns, with corresponding Postal Codes - think Zip Codes, but with letters, so they are a string of text. Town names are from A13 to A70. Corresponding Postal Codes are from B13-B70.

On Sheet 1, I have a database of addresses. Towns are in the K column and Postal Codes in L column.

I want to run a formula that automatically populates the Postal Codes in Sheet 1 L column. In otherwords, Sheet L2 would check if K2 had a match with towns in Sheet3, A13-A70, and if true, display the corresponding Postal Code. Otherwise, it would be left blank.

In other words, if I enter the same town in Sheet 1 K2 as I did in Sheet 3 A26, then Sheet 1 L2 displays Sheet 3 B26.

Many thanks in advance for your help

 

[bbott]

Welcome to the board.

In L2, try:

=IFERROR(VLOOKUP(K2,Sheet3!$A$13:$B$70,2,0),"")

 

[bhamm]

Thanks for the welcome and for the help. Worked like a charm!

 

[bbott]

Thanks for the welcome and for the help. Worked like a charm!

You're welcome.