Vlookup formula - help please...(soth)

[Soth]

Hi

Sheet A, Sheet B,
Column B Column C Column D
101 130 Consulting
103 101 Training
110 120 Hardware
120 103 Software

I'd like to have a formula in column E, that is, if items in 'Sheet A'
Column B Matches with items in 'Sheet B' Column C, then enter the result in
Column D, such as 'Training'

Is this something can be done?

Thank you,
Soth

 

[Teethless mama]

=VLOOKUP(B2,'Sheet B'!$C$2:$D$5,2,0)