Hi
I am badly needed a forumula or a trick to extract one columns related data from another sheet, i am mentioning an example below kindly any senior can help.
<tbody>
</tbody>
<tbody>
</tbody>
I am badly needed a forumula or a trick to extract one columns related data from another sheet, i am mentioning an example below kindly any senior can help.
| Sales | Smith | 1001 |
| Sales | Maria | 1002 |
| HR | Peter | 4001 |
| Sales | Maryam | 1003 |
| Sales | Paul | 1004 |
| Production | Peter Smith | 5001 |
| CEO | Jenifer | 2001 |
| CEO | Jacob | 2002 |
| Sales | Jimmy | 1005 |
| Sales | Roni | 1006 |
<tbody>
</tbody>
| Deptt Name | Employee Name | ID |
| Sales | Now i want to result in area automaticaly through vlook or any other form by matching department name | |
| HR | ||
| Production | ||
| CEO | ||
| Supply Chain |
<tbody>
</tbody>
