V
vlook fomula
i will be very thank full if any body help me .
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 required with the help of vlook formula)
10002 pen ?
10003 rubber ?
10004 Duster ?
thanks
zafar
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 required with the help of vlook formula)
10002 pen ?
10003 rubber ?
10004 Duster ?
thanks
zafar