What formula should I be using for this?

[Klyncher]

Hi all.

I am really rusty on excel so I suspect there is an easy answer to this question, but it currently eludes me.

Hopefully I can at least explain what I am trying to do!

If sheet 1, cell a2 matches and cell in sheet 2, range a:a then display the matching contents in range c:c (same row where the matching cell content was found).

 

[Fluff]

Hi & welcome to MrExcel
Have a look at Vlookup https://exceljet.net/excel-functions/excel-vlookup-function
or index/match https://exceljet.net/index-and-match

 

[Klyncher]

Thanks fluff. I looked at both. Still cannot get what I want though. Certain it’s user error, but doesn’t get me past the problem...

 

[Fluff]

Something like

Excel 2013/2016
	A	B	C
1	Name	Owner	Me
2	Tom Pearce	Owner3	Town1
3	Bill Brewer	Owner4	Town2
4	Jan Stewer	Owner5	Town3
5	Peter Gurney	Owner6	Town4
6	Peter Davy	Owner7	Town5
7	Dan'l Whiddon	Owner8	Town6
8	Harry Hawke	Owner9	Town7
Sheet2

Excel 2013/2016
	A	B
2	Bill Brewer	Town2
3	Dan'l Whiddon	Town6
Sheet1

Cell Formulas
Range	Formula
B2	=INDEX(Sheet2!$C$2:$C$8,MATCH(A2,Sheet2!$A$2:$A$8,0))

 

[Klyncher]

EXACTLY that! Thankyou! ??

 

[Fluff]

You're welcome & thanks for the feedback