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:

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]AG[/TD]
[TD="align: center"]AH[/TD]
[/TR]
[TR]
[TD="align: center"]User Story ID[/TD]
[TD="align: center"]User Story Title[/TD]
[/TR]
[TR]
[TD="align: center"]12345[/TD]
[TD="align: center"]This is My Title[/TD]
[/TR]
</tbody>[/TABLE]

​

• 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

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]ID[/TD]
[TD="align: center"]Title[/TD]
[/TR]
[TR]
[TD="align: center"]12345[/TD]
[TD="align: center"]This is My Title[/TD]
[/TR]
</tbody>[/TABLE]

 

[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:

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]Row[/TD]
[TD="align: center"]AG[/TD]
[TD="align: center"]AH[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]User Story ID[/TD]
[TD="align: center"]User Story Title[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]12345[/TD]
[TD="align: center"]This is My Title[/TD]
[/TR]
</tbody>[/TABLE]

​

• 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

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]Row[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]ID[/TD]
[TD="align: center"]Title[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]12345[/TD]
[TD="align: center"]This is My Title

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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