| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy subtotal value only, subtotal value can be vlookup by others
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup error with subtotal | Excel Worksheet Functions | |||
| Can not copy a worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Copy VLookup Values | Excel Worksheet Functions | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
