# Match A to j then L to D

#### frazzle6

##### New Member
Hi, i have items in column A and items in J.

I ran match formula which was all good. Returned results.

There is pricing in Column L which i need to have in column D if excel found a match.

Here is where i am stuck, is there a formula to do this or does have to be code.

Murray

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### jorismoerings

##### Well-known Member
Hi,

It's probable that your question makes a lot of sense to you, however, you don't provide enough details necessary to know to help you. It sound this could be solved with something like Index/Match, Lookup or VLOOKUP but....

If you want valuable help:

1. show a short sample of your worksheet
2. include the match formula you've used
4. manually insert what the answer should be so we can understand the logic.

It will give better understanding of what you're trying to do and with that; you help us to help you.

#### FDibbins

##### Well-known Member
I think you want something like this. I have shown how to pull based on 3 different criteria scenarios

 A​ B​ C​ D​ E​ F​ G​ 13​ Name header1 Header2 Name header1 Header2 14​ aa 1​ 10​ bb 2​ 20​ 15​ bb 2​ 20​ 16​ cc 3​ 30​ cc 3​ 30​ 17​ dd 4​ 40​ 18​ ee 5​ 50​ dd 4​ 40​ 19​ ff 6​ 60​ 20​ gg 7​ 70​ 21​ hh 8​ 80​ 22​ ii 9​ 90​

If you need to search by Name (E14)
F14=INDEX(B\$14:B\$22,MATCH(\$E14,\$A\$14:\$A\$22,0))

OR If you need to search by Header1 (F16)
E16=INDEX(A\$14:A\$22,MATCH(\$F16,\$B\$14:\$B\$22,0))

OR If you need to search by Header2 (G18)
E18=INDEX(A\$14:A\$22,MATCH(\$G18,\$C\$14:\$C\$22,0))

In all cases, copied across as needed

Replies
1
Views
145
Replies
1
Views
704
Replies
2
Views
370
Replies
1
Views
212
Replies
7
Views
641

1,191,388
Messages
5,986,320
Members
440,017
Latest member
vasanrajeswaran

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