vlookup of sub totals
 

Hi

I have a summary sheet that is looking at data on multiple sheets within a
workbook.
All the data in the individual workbooks is summed using sub totals.
In column A this reports the part number followed by a space then the word
Total.
I want to use vlookup to report totals in the summary sheet however the
summary sheet just contains my part number (and not the word total), as such
I get "N/a" results. Can I use a wild card in the vlookup formula and if so
what is it ?

If not any quick suggestions about how I can resolve this ?


--
thanks
Roy

vlookup of sub totals
 

If you don't need the word "total", you can use SUBSTITUTE formula to ignore
the word.

"Roy Gudgeon" wrote:

Hi

I have a summary sheet that is looking at data on multiple sheets within a
workbook.
All the data in the individual workbooks is summed using sub totals.
In column A this reports the part number followed by a space then the word
Total.
I want to use vlookup to report totals in the summary sheet however the
summary sheet just contains my part number (and not the word total), as such
I get "N/a" results. Can I use a wild card in the vlookup formula and if so
what is it ?

If not any quick suggestions about how I can resolve this ?


--
thanks
Roy

vlookup of sub totals
 

Just embed that " total" string in your =vlookup() formula:

=vlookup(a2&" total", sheet99!a:z,13,false)



Roy Gudgeon wrote:

Hi

I have a summary sheet that is looking at data on multiple sheets within a
workbook.
All the data in the individual workbooks is summed using sub totals.
In column A this reports the part number followed by a space then the word
Total.
I want to use vlookup to report totals in the summary sheet however the
summary sheet just contains my part number (and not the word total), as such
I get "N/a" results. Can I use a wild card in the vlookup formula and if so
what is it ?

If not any quick suggestions about how I can resolve this ?

--
thanks
Roy

--

Dave Peterson