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.
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.