pulling random data from another tab in spreadsheet?

D

davie670

On main page of spreadsheet I have space for names and addresses of third
party agencies we use. A separate tab (called Third Parties( contains the
full contact information for the various agencies. Is there a way I can
input the post code (Zip code) onto the main sheet and for Excel to search
the third party tab and input the third party data that matches the post
(Zip) code entered? I know how to pull information from a fixed point but
not a random one. Thank you in advance
 
F

Fred Smith

Yes, it's called Vlookup (or Index/Match depending on the layout of your
main page).

Help has good descriptions of both. Post back if you need more help, and if
so, be sure to include a layout of your data.

Regards,
Fred
 
E

Eduardo

Hi,

Let's assume your zip code is in column A and in the zip code tab you have
the zip# in A and the information to pull in column B

=INDEX(third parties!B1:B9,MATCH(A1,third parties!A1:A9,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup to copy data from another tab 2
Creating a Chart on form from selected data in query. 0
Autofill data from one tab to another under certain criteria 3
Macro to pull in specific data into multiple worksheets in a workb 0
Pulling data from one tab to another & matching it 0
Find and TRansfer from another Tab in same Worksheet 3
Migrating app from 2003 to 2010 0
Random table of data - need to find every cell that contains specific data 1

Top