| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Lookup formula - treat no-registered cells as blank | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Threaded Mode
