1. Why does a formula SOMETIMES act as a formula and in other work
book/sheet act as text? ie will produce "Joe Bloggs" if A3="Joe" and
A2="Bloggs" but in another worksheet will remain "=CONCATENATE(A3," ",A2)"
2. How do I lookup a column of text which are a result of formula? eg.
=VLOOKUP(A2,NAMES,2) where A2="Joe Bloggs" and NAMES=Array of results of
formula "=CONCATENATE(A3," ",A2)". Currently produces "N/A" even though I
KNOW that Names contains "Joe Bloggs".
Any help with this would be greatly appreciated as I only have one or two
handfulls of hair left!!
--
Bob JONES

Give me ambiguity or give me something else