Extract data through matching one column criteria.

[shezz]

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.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Sales[/TD]
[TD]Smith[/TD]
[TD]1001[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Maria[/TD]
[TD]1002[/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD]Peter[/TD]
[TD]4001[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Maryam[/TD]
[TD]1003[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Paul[/TD]
[TD]1004[/TD]
[/TR]
[TR]
[TD]Production[/TD]
[TD]Peter Smith[/TD]
[TD]5001[/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[TD]Jenifer[/TD]
[TD]2001[/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[TD]Jacob[/TD]
[TD]2002[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Jimmy[/TD]
[TD]1005[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Roni[/TD]
[TD]1006[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Deptt Name[/TD]
[TD]Employee Name[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]Sales[/TD]
[TD]Now i want to result in area automaticaly through vlook or any other form by matching department name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HR[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Production[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Supply Chain[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]