Match A to j then L to D

[frazzle6]

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.

Thanks in advance.
Murray

 

[jorismoerings]

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
3. ask a specific question
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]

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