MrPink1986
Active Member
- Joined
- May 1, 2012
- Messages
- 252
Hi,
I am trying to create a formula where I need two criteria to match to pull back a value. On my sheet Global Contacts I have a list of Vendors and a number of fields with contact information- I want to pull back the contact information for each vendor under the below headers - the unique piece of information is the vendor and on my main sheet when I input x I get all the information below and also when I input Y it updates accordingly.
<colgroup><col></colgroup><tbody>
</tbody>
I am trying the below formula - I am putting my vendor information on to my main page in cell F3. My contact information is contained in the Global Contacts sheet from A-G. The below formula is trying to pull back the Primary Contact and I understand I will need to ammend to pull back each field listed.
Below is a sample of the data I am working with
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am trying to create a formula where I need two criteria to match to pull back a value. On my sheet Global Contacts I have a list of Vendors and a number of fields with contact information- I want to pull back the contact information for each vendor under the below headers - the unique piece of information is the vendor and on my main sheet when I input x I get all the information below and also when I input Y it updates accordingly.
Primary Contact |
Primary Name |
Primary Phone |
Secondary Contact |
Secondary Name |
Secondary Phone |
Teritary Contact |
Teritary Phone |
<colgroup><col></colgroup><tbody>
</tbody>
I am trying the below formula - I am putting my vendor information on to my main page in cell F3. My contact information is contained in the Global Contacts sheet from A-G. The below formula is trying to pull back the Primary Contact and I understand I will need to ammend to pull back each field listed.
Code:
=INDEX('Global Contacts'!A:G,MATCH(1,('Global Contacts'!A:A=Main!F3)*('Global Contacts'!A:C=Main!E16),0),3)
Below is a sample of the data I am working with
X | Primary Contact | test@gmail.com |
X | Name | |
X | Phone | |
X | Contact 2 | test2@gmail.com |
X | Name | JohnDoe |
X | Phone | 1234 |
Y | Asset Types | All |
Y | Primary Contact | test3@gmail.com |
Y | Name | |
Y | Phone | |
Y | Contact 2 | test4@gmail.com |
Y | Name | Jane Doe |
Y | Phone | 456 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>