# Help with a match function

#### Mariner741

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

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
What is the outcome that you desire?

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

The value contained in E that corresponds to the name in A
Book3
ABCDE
1Joe400Jack100
2Jim500Joe400
3John#N/AJim500
4
Sheet1

B1, copied down:

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

Would a VLOOKUP work for you?
Book1
ABCDE
1Joe400Jack100
2Jim500Joe400
3John#N/AJim500
Sheet1

Replies
1
Views
191
Replies
1
Views
236
Replies
11
Views
328
Replies
4
Views
265
Replies
10
Views
551

1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

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