B
BB
I did copy subtotal value only by edit/go to/ special/visiable cell to the
sheet A. It shown part no. 31611 Total - qty 114. Then I did "find" replace
"Total" with blank field, so I can get part no. only. => part no. 31611 , qty
114 - they both on 2 different column.
Now I can't Vlookup these 2 column data. I need vlookup qty column. It
shown "#N/A" when I loopup qty column. Is this text / number issue? How can
loopup value from subtotal result?
sheet A. It shown part no. 31611 Total - qty 114. Then I did "find" replace
"Total" with blank field, so I can get part no. only. => part no. 31611 , qty
114 - they both on 2 different column.
Now I can't Vlookup these 2 column data. I need vlookup qty column. It
shown "#N/A" when I loopup qty column. Is this text / number issue? How can
loopup value from subtotal result?