extract value from a column when the criteria is met in another column

[anillinda]

I have 5 columns, I would like to populate a new column on another worksheet with following criteria:

Populate column 1 with description when the subtype is raw material. I want to do this by using a formula,

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Gl Account[/TD]
[TD]Description[/TD]
[TD]Asset[/TD]
[TD]Subtype[/TD]
[TD]Period Balance[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Bank Account[/TD]
[TD]Asset[/TD]
[TD]Cash[/TD]
[TD]5000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123457[/TD]
[TD]Petty Cash[/TD]
[TD]Asset[/TD]
[TD]Cash[/TD]
[TD]265[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123458[/TD]
[TD]Account Receivable[/TD]
[TD]Asset[/TD]
[TD]Receivables[/TD]
[TD]25864[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123459[/TD]
[TD]Accounts Payable[/TD]
[TD]Liability[/TD]
[TD]Payables[/TD]
[TD]15860[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123460[/TD]
[TD]Wages[/TD]
[TD]COGS[/TD]
[TD]Direct Labor[/TD]
[TD]3650[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ravishankar]

I think you can use VLOOKUP function.
Ravi shankar