What kind of formula would work ?

[aaple]

Great forums as I'm learning how to use excel, I am a super noobie. Thanks for reading my thread/question.

I have a workbook, i would like to try something in the worksheet. as i setup the data for tables in sheet1:
co name contact person
intel
amd
asus
abit
msi
ati
dlink
belkin
intel
intel
belkin
amd
sony
intel
etc...

In the same workbook, as i have another table in sheet2:
co name contact person
ati steve
amd steve
belkin mike
dlink mike
msi chris


my question is, how can i match the company name from sheet2 to sheet1, and if there is a successful match, can i have sheet2 name of contact person automatically insert the name underneath contact person in sheet1? hope that is not a complex question, just want to know which formula i should use.

basically, in sheet 1, i would like to know the contact person from sheet 2.

 

[shyrath]

have a look at Vlookup , which will return the first match from sheet1 to sheet2.

So if your comp name is in A and person in B

it would be something like this to put in sheet2

=vlookup(A1,sheet1!A:B,2,false)

Excel Workbook
	A	B	C	D	E	F	G
1	Sheet1			Sheet2
2	Comp	Person		Comp	Person	person from Sheet1
3	Intel	John		Intel	Jim	John
4	Microsoft	Jake		Microsoft	Jenn	Jake
Sheet1

 

[Chris Bode]

In such case vlookup should help
select cell B1 in sheet1 and enter following formula
=VLOOKUP(A2,Sheet2!A2:B4,1,FALSE)

 

[aaple]

^super great, that did the trick! kudos!!

 

[aaple]

thanks shyrath & Chris Bode.