Vlookup & Subtotals

  • Thread starter Thread starter Paul Gray
  • Start date Start date
P

Paul Gray

I have a subtotaled sheet from an external data source with only tw
columns( part#, qty) on another sheet I have my vlookup statement whic
has the part# column, how can I get the vlookup to ignore the wor
total on the subtotal page.
The statement I am using is vlookup(a1,sheet4!A:B,2,false)
This worked fine until I chose to go the external data route.
Thanks in advance for any idea
 
Are you sure you want to ignore the word Total? It kind of sounds like you want
it to only retrieve the data from the total row????

=vlookup(a1&" total",sheet4!A:B,2,false)

If I guessed correctly...

You may want to look at data|pivottables (instead of using subtotals). I find
them quicker and you only get the totals--none of the details show in the
pivottable.
 
Back
Top