| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace common material in 2 sheets
I have sheet1 and sheet2 both sheets have same data but there are some new
material # in sheet1. Problem is when apply Vlookup formula in sheet2 then quantities of new material numbers do not comes because these new materials numbers do not exist in sheet2. Is there any method? To trace new or diff. materials numbers those are exist in sheet1 Regards Zafar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trace dependent tool doesn't work but trace precendent doesn't | Excel Discussion (Misc queries) | |||
| unifying two sheets by a common index column | Excel Discussion (Misc queries) | |||
| Conditional formatting - Find common material | Excel Worksheet Functions | |||
| Common range name for 2 sheets | Excel Discussion (Misc queries) | |||
| making one material list from mulitple vendor material lists | Excel Worksheet Functions | |||
Threaded Mode
