pulling random data from another tab in spreadsheet?

  • Thread starter Thread starter davie670
  • Start date Start date
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
 
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
 
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))
 
Back
Top