Some kind of look up?

[jackdiamond]

Good morning all,

Hopefully someone can help me

I have a range of data in Column B and I will paste in more data into column E. What I want to do is match any data in column E with the data in Column B. Does that make sense?

So If in column E we have "4996", I want to match it if there is also "4996" in column B

Could a formula move that data on the corresponding line?

Thanks in advance for any help!

 

[Special-K99]

Please supply some example data with expected output covering both matching and non-matching data.

 

[jackdiamond]

B E F
61624 45465 22345
22345 14515 2652
2145 2652
2658 22345
2652 9998

So anything that is in column E, if it is matched in column B it will be displayed in column F

Does that make sense? Sorry, bit vague!

 

[Special-K99]

This should be easy but I'm having trouble with it

 

[FormR]

Hi, here is one option if I've understood correctly.

Excel 2013/2016
	B	C	D	E	F
1	61624			45465	22345
2	22345			14515	2652
3	2145			2652
4	2658			22345
5	2652			9998
Sheet1

Cell Formulas
Range	Formula
F1	=IFERROR(INDEX($B$1:$B$5,AGGREGATE(15,6,ROW($B$1:$B$5)-ROW($B$1)+1/ISNUMBER(MATCH($B$1:$B$5,$E$1:$E$5,0)),ROWS($F$1:F1))),"")