| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
| convert vlookup formula to link formula | Excel Worksheet Functions | |||
| VLOOKUP FORMULA? | Excel Discussion (Misc queries) | |||
| Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
| How do I set up vlookup formula. | Excel Worksheet Functions | |||
Linear Mode
