Hello guys :)
Thanks for viewing my thread, I have some question regarding on using VLOOKUP+randomized data.
Sheet1
<code>branchID
BRANCH01
BRANCH02
BRANCH03
BRANCH04
</code> Sheet2
<code>employeeID
EMPLOYEE01 -- BRANCH01
EMPLOYEE02 -- BRANCH01
EMPLOYEE03 -- BRANCH02
EMPLOYEE04 --...