Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help required about vlookup formula
Sheet A has
Col A: Inventory code Col B: Description Col C: Quantity Sheet B has Col A: Inventory code Col B: Description Col C: Quantity ( both sheets have same data but inventory code may be different) Sheet C required Required: total quantity of sheet A and sheet B in Col. C of sheet C Kindly help me to create a logical formula / vlook formula Example Sheet A Col A Col B Col C Inventory code Description Quantity 10001 pencil 25 10002 pen 50 10003 rubber 75 Sheet B Col A Col B Col C Inventory code Description Quantity 10001 pencil 25 10002 pen 50 10004 Duster 15 Sheet C Col A Col B Col C Inventory code Description Total Qty of sheet A & Sheet B 10001 pencil ? ( total required with the help of vlok 10002 pen ? 10003 rubber ? 10004 Duster ? zafar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a vlookup formula without changing the "table_array" p | Excel Worksheet Functions | |||
Find value in array | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |