excelnewbieneedhelp
New Member
- Joined
- Apr 6, 2018
- Messages
- 3
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 -- BRANCH02
EMPLOYEE05 -- BRANCH03
EMPLOYEE06 -- BRANCH03
EMPLOYEE07 -- BRANCH04
EMPLOYEE08 -- BRANCH04
What I want for the result -
Sheet3
BRANCHID EMPLOYEEID
</code><code><code>BRANCH01 </code></code><code><code><code>EMPLOYEE01 </code>
<code><code><code><code><code>BRANCH01 EMPLOYEE02
BRANCH03 EMPLOYEE05
BRANCH03 EMPLOYEE06
BRANCH04 EMPLOYEE07
BRANCH01 EMPLOYEE02
BRANCH01 EMPLOYEE01
BRANCH02 EMPLOYEE03
which that the employeeID is depending on branchid (and it will randomized the value between(EMPLOYEE01 & EMPLOYEE02) whenthe branchid is BRANCH01, sames goes to BRANCH02 (EMPLOYEE03 &EMPLOYEE04) , BRANCH03 (EMPLOYEE05 & EMPLOYEE06) , BRANCH04(EMPLOYEE07 & EMPLOYEE08)</code></code></code></code></code></code><code><code><code><code><code>
</code></code></code></code></code>
</code>
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 -- BRANCH02
EMPLOYEE05 -- BRANCH03
EMPLOYEE06 -- BRANCH03
EMPLOYEE07 -- BRANCH04
EMPLOYEE08 -- BRANCH04
What I want for the result -
Sheet3
BRANCHID EMPLOYEEID
</code><code><code>BRANCH01 </code></code><code><code><code>EMPLOYEE01 </code>
<code><code><code><code><code>BRANCH01 EMPLOYEE02
BRANCH03 EMPLOYEE05
BRANCH03 EMPLOYEE06
BRANCH04 EMPLOYEE07
BRANCH01 EMPLOYEE02
BRANCH01 EMPLOYEE01
BRANCH02 EMPLOYEE03
which that the employeeID is depending on branchid (and it will randomized the value between(EMPLOYEE01 & EMPLOYEE02) whenthe branchid is BRANCH01, sames goes to BRANCH02 (EMPLOYEE03 &EMPLOYEE04) , BRANCH03 (EMPLOYEE05 & EMPLOYEE06) , BRANCH04(EMPLOYEE07 & EMPLOYEE08)</code></code></code></code></code></code><code><code><code><code><code>
</code></code></code></code></code>
</code>