Lookup into multiple columns

[Velven]

Good Day Guys/Girls.

I'm trying to look up A2:A4 in E2:G6 and return D.

It seems I'm required to resort to Vlookup Array Constants ?

How do I go about it ?

Account	Desired Results		Name	Account 1	Account 2	Account 3
11823236	Rueben		Nathanael	1320165485	10098830	8293341024
10885305	Rubin		Rueben	1746022069	11823236	8191322385
8739531327	Rolland		Rolland	1810570142	11196776	8739531327
			Rubin	1090197910	10885305	8952691828
			Maurice	1220148539	18966809	8659280452

<tbody>
</tbody>

Thanks
Wan

 

[Marcelo Branco]

Maybe...

	A​	B​	C​	D​	E​	F​	G​
1​	Account​	Desired Results​		Name​	Account 1​	Account 2​	Account 3​
2​	11823236​	Rueben​		Nathanael​	1320165485​	10098830​	8293341024​
3​	10885305​	Rubin​		Rueben​	1746022069​	11823236​	8191322385​
4​	8739531327​	Rolland​		Rolland​	1810570142​	11196776​	8739531327​
5​				Rubin​	1090197910​	10885305​	8952691828​
6​				Maurice​	1220148539​	18966809​	8659280452​

Array formula in B2 copied down
=INDEX(D$2:D$6,SMALL(IF(E$2:G$6=A2,ROW($E$2:$G$6)-ROW(E$2)+1),1))
confirmed with Ctrl+Shift+Enter not just Enter

M.

 

[Velven]

Many Thanks ! Marcelo

It works like a CHARM !

Wan