HelpMeWithExcelPlease
New Member
- Joined
- Jul 27, 2017
- Messages
- 24
Hi all,
I am working with the following data and am trying to identify the appropriate formula to use to speed up this process. I do not have a ton of familiarity with INDEX(MATCH()) formulas, and I think what I am looking for cannot be satisfied by a VLOOKUP() alone. Any ideas on what I can do would be greatly appreciated!
I have data from a few different documents that I am trying to consolidate into one worksheet. Those input tables are shown in the below two tables:
Input Table #1
<tbody>
</tbody>
Input Table #2
<tbody>
</tbody>
The worksheet I am trying to consolidate the data on to looks like the below sample table. What I am looking for is a formula (or formulas) to put in cells C2:F8 that will pull in the "X" from the Input tables if applicable.
Consolidated Table
<tbody>
</tbody>
Any assistance, suggestions, or resources that you all can provide would be awesome, thank you in advance!
I am working with the following data and am trying to identify the appropriate formula to use to speed up this process. I do not have a ton of familiarity with INDEX(MATCH()) formulas, and I think what I am looking for cannot be satisfied by a VLOOKUP() alone. Any ideas on what I can do would be greatly appreciated!
I have data from a few different documents that I am trying to consolidate into one worksheet. Those input tables are shown in the below two tables:
Input Table #1
Defect ID | Field Name | Interface #1 | Interface #2 |
1 | first_name | X | |
2 | last_name | X | |
2 | zip_code | X |
<tbody>
</tbody>
Input Table #2
Defect ID | Field Name | Interface #3 | Interface #4 |
2 | zip_code | X | |
3 | phone_number | X | |
4 | first_name | X | |
5 | state_ID | X |
<tbody>
</tbody>
The worksheet I am trying to consolidate the data on to looks like the below sample table. What I am looking for is a formula (or formulas) to put in cells C2:F8 that will pull in the "X" from the Input tables if applicable.
Consolidated Table
Defect ID | Field Name | Interface #1 | Interface #2 | Interface #3 | Interface #4 |
1 | first_name | ||||
2 | last_name | ||||
2 | zip_code | ||||
3 | phone_number | ||||
4 | first_name | ||||
4 | work_address | ||||
5 | state_ID |
<tbody>
</tbody>
Any assistance, suggestions, or resources that you all can provide would be awesome, thank you in advance!