Formula: How match data from from cell to entire column of data

[serenalove]

I am trying to match data from two different Sheets, and bring in Data from Sheet 2 to Sheet 1 based upon matching criteria. Below is an example format:

SHEET 1:

ColumnA:
Row 1. Company Name
Row 2. Company A
Row 3. Company B
Row 4. Company C
Row 5. Company D


SHEET 2:

ColumnA / ColumnB::
Row 1. Company Name / Account Owner:
Row 2. Company C / Jessica
Row 3. Company A / David
Row 4. Company D / Ken
Row 5. Company B / John

IF a Company Name from a cell in Column 1 in Sheet 1 has a match anywhere in Column 1 in Sheet 2, I need to display the Account Owner (the adjacent cell) of that matching record in Sheet 1 next to the company name. Problem is Sheet 2 has way more Company Names than Sheet 1, so I need to look through a hole column of data to find a match.

FINAL:

ColumnA / ColumnB::
Row 1. Company Name / Account Owner:
Row 2. Company A / David
Row 3. Company B / John
Row 4. Company C / Jessica
Row 5. Company D / Ken

I have no idea which formula will work for this. Thanks!

 

[Aladin Akyurek]

Try...

Sheet1, B2

=INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0))

 

[scottylad2]

Excel Workbook
	J	K	L	M	N
52
53	sheet 1			sheet 2
54	company a	David		company c	sally
55	company b	jess		company b	jess
56	company c	sally		company d	robert
57	company d	robert		company c	sally
58	company e	mike		company a	David
59
Course Dates

 

[serenalove]

Great thank you! First one worked!