jmartin2178
New Member
- Joined
- Jun 10, 2019
- Messages
- 14
I am looking to pull in the the Title from another spreadsheet in the excel document based on the data matching. Hopefully below will help explain a little bit better.?. Is this possible to achieve?
Main Spreadsheet:
<tbody>
</tbody>
"Defect to User Story" Spreadsheet located on another tab in same excel file
<tbody>
</tbody>
Main Spreadsheet:
AG | AH |
User Story ID | User Story Title |
12345 | This is My Title |
<tbody>
</tbody>
- Need to use data in column AG (User Story ID) and match to data in separate spreadsheet (Defect to User Story) column A and if matches pull in the Title from the separate spreadsheet (Defect to User Story) column C into the Main Spreadsheet column AH.
"Defect to User Story" Spreadsheet located on another tab in same excel file
A | C |
ID | Title |
12345 | This is My Title |
<tbody>
</tbody>