vlookup Question

[jmartin2178]

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:

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>

 

[Fluff]

Are these two sheets in the same workbook, or are they sheets in two different workbooks?

 

[jmartin2178]

Are these two sheets in the same workbook, or are they sheets in two different workbooks?

Same workbook

 

[Fluff]

In that case try
=VLOOKUP(AG2,'Defect to User Story'!A$2:C$25,3,0)

 

[jmartin2178]

Getting a #NA Error

I tired changing AG2 to AG3 based on the start of the data in rows shown below...getting same #NA .

=VLOOKUP(AG3,'Defect to User Story'!A$2:C$25,3,0)


* If AG3 matches A3 from Defect to User Story, then place C3 contents into the AH3 cell onto Main spreadsheet.


Main Spreadsheet:

Row	AG	AH
2	User Story ID	User Story Title
3	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

Row	A	C
2	ID	Title
3	12345	This is My Title

<tbody>
</tbody>

 

[Fluff]

That means that it can't find the value of AG3 in Col A of the other sheet.
Check that the values in both sheets don't contain leading/trailing spaces.
Also make sure that both values are text, or both are numeric.

 

[jmartin2178]

That means that it can't find the value of AG3 in Col A of the other sheet.
Check that the values in both sheets don't contain leading/trailing spaces.
Also make sure that both values are text, or both are numeric.

Got it! I changed the cell from AG to P as I was using a formulas in AG. Once I changed to the original cell P and updated to Number instead of text it worked.

Thanks!

 

[Fluff]

You're welcome & thanks for the feedback