Are you using VLOOKUP function?

Which column is the Postal Code in?

Must be first column for VLOOKUP.

Show us the formula you are using.

To return 8 columns of info based on Postal Code you will need 8 VLOOKUP
formulas per row.


Gord Dibben MS Excel MVP


On Tue, 16 Mar 2010 15:27:02 -0700, davie670
wrote:

I have two tabs in spreadsheet. MAIN & THIRD PARTY I'm trying to update
third party contact information from THIRD PARTY to MAIN by entering a POST
CODE (ZIP CODE) into MAIN and for the formula to search the THIRD PARTY tab
and return the name, address and contact info there.

Basic info in THIRD PARTY covers NINE columns that should be copied and
transferred to MAIN if the post code matches.

I can get it to look but not to search the columns for the variable. I have
sorted the spreadsheet into into order. Thanks in advance fro your help.

David