Vlookup, as all other functions, will calculate on the *results* of any
formula contained in the referenced cell.

Your issue here is, I'll bet, that your data just *doesn't* match!

Re-type the name
Joe Bloggs
into A2.

Now, go to your "Names" range.
You can shorten your formula to,
=A3&" "&A2
Re-enter Joe in A3
Re-enter Bloggs in A2
Make sure you do this exactly the same way as you did in the lookup cell A2.
Make sure you don't inadvertently add any spaces!

It should work now.

If it does, that means that you might have invisible characters in either of
the concatenated cells or the lookup cells.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Bob Jones" wrote in message
...
"Bob Phillips" wrote in message
...
1. Check ToolsOptionsView 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

Give me ambiguity or give me something else