Prev: macro - copy/add to another sheet
Next: Refresh pivot chart when info in a cell changes
From: davie670 on 9 Mar 2010 14:38
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
From: Fred Smith on 9 Mar 2010 14:45
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" <davie670(a)discussions.microsoft.com> wrote in message
news:73D72BBC-2E6B-4183-9BCA-987572A76DBF(a)microsoft.com...
> 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

From: Eduardo on 9 Mar 2010 14:56
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
 | 
Pages: 1
Prev: macro - copy/add to another sheet
Next: Refresh pivot chart when info in a cell changes