vlookup Question

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:

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

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Are these two sheets in the same workbook, or are they sheets in two different workbooks?
 
Upvote 0
In that case try
=VLOOKUP(AG2,'Defect to User Story'!A$2:C$25,3,0)
 
Last edited:
Upvote 0
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]
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,224,821
Messages
6,181,163
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top