subtotals value can be vlookup by another worksheet
Here is my problem:
I have sheet #1 contains part no. A with on hand qty 10 pcs= book qty.
col 1 col. 2
part no. book qty
A 10
Now we are doing physical count - I have a new sheet #2 = it subtotal part
no. A (it has 3 count tags on this part) with subtotal qty 25pcs
The result subtotal shown on sheet#2:
part no. tag qty
A 1 20
A 2 3
A 3 2
A Total 25 = this is a subtotal line
I would like to use sheet #1 and vlookup phy qty associate part no. A data
from sheet #2:
col. 1 col. 2 col. 3
part no. book qty physical qty
A 10 25 - this data from vlookup on
sheet #2 subtoal value.
However, it always shown col. 3 - #N/A, it won't lookup subtotal qty from
part no. A
Please reply.
Thank you,
BB
"Marcelo" wrote:
Hi, subtotal value can be vlookup, assuming that you have a table
Col A Col B
a 1
a 1
a 1
a 1
a Total 4
b 3
b 2
b 6
b Total 9
use =Vlookup("a Total",a2:b90,0)
hth
regards from Brazil
Marcelo
"BB" escreveu:
Is subtotals value a text field ? Why can't I vlookup the value from other
worksheet?
Any solution? so I can lookup the subtotals value.
Need helps urgently...
Thank you,
|