How to find information

[468gurgurf]

Hello! I want to start with a value in column C2 (afterwards C3, C4, C5 and so on), find that exact same value in column L, copy the value next to the duplicated value in Column M, and then afterwards insert the value from column M in D2 (afterwards D3,D4,D5 and so on). Is there any way to do this automatically, and if so, how?

 

[RobP]

Hi,

if you are using Excel version O365, you could put this formula into cell D2.
cheers
Rob

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Values	Result								List
2			10	200								5	100
3			20	400								10	200
4			30	600								15	300
5			40	800								20	400
6			50	1000								25	500
7			60									30	600
8			70									35	700
9			80									40	800
10			90									45	900
11			100									50	1000
Sheet1

Cell Formulas
Range	Formula
D2:D11	D2	=IFERROR(CHOOSECOLS(FILTER(L2:M11,$L2:L11=$C2),2),"")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)