vlookup of sub totals

[Roy Gudgeon]

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 ?

 

[vishu]

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

 

[Dave Peterson]

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

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