View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steven Vegeta Steven Vegeta is offline
external usenet poster
 
Posts: 4
Default is it possible to do lookup with cells containing tildes "~"?

Hi there,

I've been using vlookup on my tables and just discovered that the lookup
actually failed when the cell contains one or more tildes "~" (well never
really use a tilde for it's special purpose before).

Is there any way that Excel's lookup can match my titles with tildes as well
? if not then I guess I'll have to replace all my tildes in my cells to other
signs......probably hyphens.

Many Thanks in advance!

Steven Vegeta