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 ?
<tbody>
Account
Desired Results
Name
Account 1
Account 2
Account 3
11823236
Rueben
Nathanael
1320165485
10098830
8293341024...