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