| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help me for exact Formula
I have data on sheet1 & sheet2 and I want to apply formula on sheet3 to link
the Qty. while I have try with Vlookup and Sumif but got success only as Vlookup(sheet1€¦..)+Vlookup(sheet2€¦..) Sheet1 Code Imported Material Qty 101 A 5 300 B 10 400 C 7 Sheet2 Code Local Material Qty 102 X 3 104 Y 8 203 Z 2 Sheet3 Code Material used Qty 101 A 5 102 X 3 104 Y 8 203 Z 2 300 B 10 400 C 7 Thanks Zafar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
| Exact formula 3 Columns | Excel Worksheet Functions | |||
| EXACT Formula needed? | Excel Discussion (Misc queries) | |||
| How to do the exact copy of a formula | Excel Worksheet Functions | |||
| EXACT formula | Excel Discussion (Misc queries) | |||
Threaded Mode
