format will not work in this case because

it doesn't change the nature of the cell.  Hopefully we are talking about the same issue and you undersdand what I'm talking about...

1. Add a column next to the lookup_value and also the first cloumn of the table_array. 

2. Then use the clean function to clean up both 2 columns. 

3. Then use the vlookup targeting with the new columns.

所有跟帖： 

• Thank you very much and will try it tomorrow.Have a nice weekend -airsusan- ♀ (0 bytes) () 08/05/2011 postreply 16:15:04