pulling random data from another tab in spreadsheet?
 

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

pulling random data from another tab in spreadsheet?
 

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

"davie670" wrote in message
...
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

pulling random data from another tab in spreadsheet?
 

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))

"davie670" wrote:

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