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>
</tbody>
Thanks
Wan
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