VLookup, Match, Index?

[mlarson]

Hi there! I hope I'm being clear on this question. I'm unsure if it's VLookup, Match, Index, etc.? Thanks in advance for your help!

I have 2 spreadsheets. Sheet 1 is where I want the output and formula to be. If a name in column C of Sheet 1 matches a name in column C of sheet 2, then I'd like the data in column R of Sheet 2 (that is in the same row as the matched name) to populate in column I of sheet 1. If no name matches, then leave column I of sheet 1 blank.

Thank you!
Mark

 

[AhoyNC]

Try:

Excel Workbook
	C	D	H	I
3	Name			Data
4	Name1			Test1
5	Name2
6	Name3			Test3
7	Name4			Test4
8	Name5
9	Name6			Test6
Sheet1

Excel Workbook
	C	D	Q	R
1	Name			Data
2	Name1			Test1
3	Name12			Test2
4	Name3			Test3
5	Name4			Test4
6	Name55			Test5
7	Name6			Test6
Sheet2

 

[mlarson]

AhoyNC, thank you for your reply! I tried that formula but all the ouptut came back blank. Any ideas on why that might be?

 

[mlarson]

Not sure if it matters, but the data in Column R of Sheet 2 are numbers. Data in column C of both sheets are letters/words.

 

[AhoyNC]

Check to see if you have an actual match between an item on sheet1 and sheet2 in columns C. Where does the data come from, is it downloaded. Could there be spaces either before or after a name in either Sheet1 or Sheet2?

 

[mlarson]

Doh! I only included one quotation mark " instead of two "" in the formula. Thank you for your time and it's working well! Thanks again!

 

[AhoyNC]

Glad it was an easy fix. Thanks for the feedback.