ExcelBanter - Vlookup formula - help please...(soth)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup formula - help please...(soth) (https://www.excelbanter.com/excel-worksheet-functions/186930-vlookup-formula-help-please-soth.html)

Soth

Vlookup formula - help please...(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 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

All times are GMT +1. The time now is 04:10 PM.