# What kind of formula would work ?

#### aaple

##### New Member
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
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
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.

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### shyrath

##### Active Member
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
ABCDEFG
1Sheet1Sheet2
2CompPersonCompPersonperson from Sheet1
3IntelJohnIntelJimJohn
4MicrosoftJakeMicrosoftJennJake
Sheet1

#### Chris Bode

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

#### aaple

##### New Member
^super great, that did the trick! kudos!!

Replies
6
Views
645
Replies
1
Views
231
Replies
4
Views
773
Replies
5
Views
501
Replies
1
Views
909

1,191,671
Messages
5,987,956
Members
440,121
Latest member
eravella

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back