subtotals value can be vlookup by another worksheet
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,
|