Look up and return value from another colunm

[pateln1594]

I have run into a problem. So I have 2 colunms as follows:

A B C D
1 123
2 444 9
3 666
4 888 7
5 123
6 666 3
7 123 1
8 444
9 444
10 666


So I want to look in Column A for the value 123 and Return the value 1 from B7 since its associated with 123. Since there are multiple 123's in Column A I am not able to get the correct result. I tried using Vlookup and Lookup. I am not getting how to do this. Please help!!

 

[pateln1594]

.........a...........b...........c.............d
1.....123....... ........
2.....444....... 9 ........
3.....666....... ........
4.....888....... 7 ........
5.....123....... ........
6.....666....... 3 ........
7.....123....... 1 ........
8.....444....... ........
9.....444....... ........
10...666....... ........

 

[Marcelo Branco]

Welcome to Mr Excel forum

Maybe something like this

	A​	B​	C​	D​	E​
1​	123​			Value​	Result​
2​	444​	9​		123​	1​
3​	666​			444​	9​
4​	888​	7​		666​	3​
5​	123​
6​	666​	3​
7​	123​	1​
8​	444​
9​	444​
10​	666​
11​

Formula in E2 copied down
=SUMIF(A:A,D2,B:B)

Hope this helps

M.

 

[pateln1594]

welcome to mr excel forum

maybe something like this

	a​	b​	c​	d​	e​
1​	123​			value​	result​
2​	444​	9​		123​	1​
3​	666​			444​	9​
4​	888​	7​		666​	3​
5​	123​
6​	666​	3​
7​	123​	1​
8​	444​
9​	444​
10​	666​
11​

<tbody>
</tbody>

formula in e2 copied down
=sumif(a:a,d2,b:b)

hope this helps

m.

thanks bud! This did the trick