Vlookup & Subtotals

[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

 

[Dave Peterson]

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.