Help with a match function

[Mariner741]

Hey, I was hoping someone could help me figure out how to do this relatively simple function.

I have a column of names in A, a column of names in D and values associated with the D-Names in E. The names in A and D are not necessarily the same.

What I am looking to do is match the data in E with the names in A. For example:

Cell A1 is Joe, A2 is Jim, A3 is John... D1 is Jack, D2 is Joe, and D3 is Jim... E1 is 100, E2 is 400, E3 is 500

Since D and E are associated with one another, Jack is 100, Joe is 400, and Jim is 500. I am trying to get those values to match the corresponding names in column A. Does anyone know how I can go about this?

What I have tried, and maybe it makes it easier to understand, is I ran a match function from names in A to column D. So in B I have a # after each guy for their place in column D. Is there a formula I can put where I can get it to take a value from a set column and a row depending on the # in the =match box?

Something along the lines of '=column(E), row (B1)'

I hope this question makes some sense to you and I appreciate any assistance.

 

[Aladin Akyurek]

What is the outcome that you desire?

 

[Mariner741]

The value contained in E that corresponds to the name in A

 

[Aladin Akyurek]

The value contained in E that corresponds to the name in A

Book3
	A	B	C	D	E
1	Joe	400		Jack	100
2	Jim	500		Joe	400
3	John	#N/A		Jim	500
4
Sheet1

B1, copied down:

=INDEX($E$1:$E$3,MATCH(A1,$D$1:$D$3,0))

 

[Brian from Maui]

Would a VLOOKUP work for you?

Book1
	A	B	C	D	E
1	Joe	400		Jack	100
2	Jim	500		Joe	400
3	John	#N/A		Jim	500
Sheet1