Re: formula OR text

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uIvqNEYoFHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
> 1. Check Tools>Options>View and make sure that Formulas is not checked.
>
Formulas not checked. Problem was cell formatted as Text when data imported
from .txt file. Kept format as General and it worked
> 2. Try =VLOOKUP(A2,NAMES,2,False) in case they are not ordered.
>
Have tried both ways. Neither worked. Suspect VLOOKUP looks at actual
content of cell rather than result of formula, hence "Joe Bloggs" not
contained in "=CONCATENATE(A3," ",A2)
--
Bob JONES
spam-trap@device>nul.net.au
Give me ambiguity or give me something else


.

Relevant Pages

  • William BLUE & Elizabeth WILLIAMS
    ... "Experiment").I don't have any other info. on them other than William was ... Bob JONES ... Give me ambiguity or give me something else ... Prev by Date: ...
    (soc.genealogy.britain)
  • formula OR text
    ... How do I lookup a column of text which are a result of formula? ... KNOW that Names contains "Joe Bloggs". ... Give me ambiguity or give me something else ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Unambiguous Sounds
    ... You can play with any ambiguity, to enhance it or to minimize it. ... Joe ... Prev by Date: ...
    (rec.music.compose)
  • Re: DateTime.AddMonths bug?
    ... I don't see that there's any ambiguity in your situation ... Jon Skeet - ... If replying to the group, please do not mail me too ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How do I find assistant codes, because my friend has a HTML of an.
    ... ..Net Developer ... Ambiguity has a certain quality to it. ... Prev by Date: ...
    (microsoft.public.frontpage.programming)