Use the tilde to tell any function that can use wildcards that you actually
are looking for this particular string, as an example

=VLOOKUP("~*KwH Per Month",Table,2,0)


will look for the string "*KwH Per Month"


--


Regards,


Peo Sjoblom





"Tim879" wrote in message
oups.com...
HI,

I'm trying to lookup (using vlookup) the string "*KwH Per Month". My
problem is that the * is not intended to be a wildcard character.

When I download the source report from SAP, it puts a * at the end to
signify that it is a total row.

I have tried using find / replace to replace * with Total and I got
the expected result of everything in the spreadsheet being replaced
with the word "Total".

I also tried the following formulas and both only return the first row
with KwH Per Month, not the *KwH Per Month row.

A4 contains the string KwH Per Month and Char (42) is ascii for *

=VLOOKUP(CHAR(42)&A4,'[ZMTIRR Summary.xls]Oct07 '!$A:$H,4,FALSE)

=VLOOKUP("*"&A4,'[ZMTIRR Summary.xls]Oct07 '!$A:$H,4,FALSE)