Vlookup formula - help please...(soth)
=VLOOKUP(B2,'Sheet B'!$C$2:$D$5,2,0)
"Soth" wrote:
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
|