Need a formula

[Yolandi]

Good day,
I have a spread sheet that consists of two sheets, sheet one has my sales agent in colum A and dealer codes from B-L, sheet two has die dealer code in colum A, dealer name in colum B and in Colum C I need to find the correct sales agent from sheet one for the specific dealer

Please help

 

[Scott T]

Excel 2010
	A	B
1	sales agent	dealer code
2	bob	1
3	rick	2
4	glave	3
5	beth	96
6	ann	67
7	mike	4
Sheet1

Excel 2010
	A	B	C
1	dealer code	dealer name	sales agent
2	67	A	ann
3	96	B	beth
4	3	C	glave
5	2	D	rick
6	1	E	bob
7	3	F	glave
8	4	G	mike
Sheet2

Cell Formulas
Range	Formula
C2	=INDEX(Sheet1!$A$2:$A$7,MATCH(A2,Sheet1!$B$2:$B$7,0))
C3	=INDEX(Sheet1!$A$2:$A$7,MATCH(A3,Sheet1!$B$2:$B$7,0))
C4	=INDEX(Sheet1!$A$2:$A$7,MATCH(A4,Sheet1!$B$2:$B$7,0))
C5	=INDEX(Sheet1!$A$2:$A$7,MATCH(A5,Sheet1!$B$2:$B$7,0))
C6	=INDEX(Sheet1!$A$2:$A$7,MATCH(A6,Sheet1!$B$2:$B$7,0))
C7	=INDEX(Sheet1!$A$2:$A$7,MATCH(A7,Sheet1!$B$2:$B$7,0))
C8	=INDEX(Sheet1!$A$2:$A$7,MATCH(A8,Sheet1!$B$2:$B$7,0))

 

[Yolandi]

Hi Scot T, soI tried tour formula but it doesnt work, I need to search the dealer code on sheet two to match sheet one and give me the sales agent name. Please refer to my query above to see which sheet has what info

 

[Scott T]

Can you post a sample of your data. The formula I posted returns the agent name based on the dealer code.

 

[Yolandi]

Hi can you send me your email then I can send you the data

 

[Scott T]

You should post a small sample here. You can change the data if need so as not to post any thing that should not be posted on the formula.