vlookup to copy data from another tab

[davie670]

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

 

[Gord Dibben]

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

 

[L. Howard Kittle]

Try something like this.

On sheet1 select 8 cells in the row you want the info to display.
Enter this formula and while still selected commit with Ctrl + Shift +
Enter, (Array-Enter). Excel will put curly brackets, { } around the
formula. Don't put them in yourself.


=VLOOKUP(A1,Sheet2!E1:M20,{2,3,4,5,6,7,8,9},0)

Where A1 is the zip code on sheet1 you want to lookup.
Where column E on sheet2 is a list of all the zip codes, and columns F to M
hold the information to be returned. Down 20 rows in this example.

If you need to make changes to the formula, you will need to reselect all
eight cells, make the change and Array-Enter again.

As Gord says, would be good to see what formula you are trying along with a
bit more info on the lay out.

HTH
Regards,
Howard