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