Hi Jquest:Jquest said:Hi guys
I have data on a sheet that as "~" exp: (~notht~125)
and for some reason excel can't find them why
Thank you
y040108h1.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | a | ~Notht~125 | k | a | ~Notht~125 | ~Notht~125 | #N/A | |||
3 | b | ~Notht125 | p | ~Notht125 | #N/A | |||||
4 | c | Notht~125 | 5 | Notht~125 | #N/A | |||||
5 | Notht125 | #N/A | ||||||||
6 | ||||||||||
7 | itisinteresting--theuseof~intheLOOKUPvalueisnotpermitted | |||||||||
8 | fromthetwoexampleshere--itappearsthatthe~mayappearinthevaluetobeLOOKEDUP | |||||||||
9 | butaslongasavaluewithoutthe~(tildecharacters)isavailableasLOOKUP, LOOKUPvalueswithandwitout~areconsideredtobeequivalent | |||||||||
10 | ||||||||||
11 | ||||||||||
12 | a | ~Notht~125 | k | a | ~Notht~125 | ~Notht~125 | s | |||
13 | b | ~Notht125 | p | ~Notht125 | s | |||||
14 | c | Notht~125 | 5 | Notht~125 | s | |||||
15 | d | Notht125 | s | Notht125 | s | |||||
16 | ||||||||||
Sheet4 |
Jquest said:Hi guys
I have data on a sheet that as "~" exp: (~notht~125)
and for some reason excel can't find them why
Thank you
Book2 | ||||||||
---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | |||
1 | LTable | Lookupvalue | Retrievalresult | |||||
2 | ~Notht~125 | fra | ~Notht~125 | fra | ||||
3 | ~Notht125 | xsa | ~Notht125 | xsa | ||||
4 | Notht~125 | zxa | Notht~125 | zxa | ||||
5 | Notht125 | dra | Notht125 | dra | ||||
6 | ||||||||
Sheet1 |