"Minos" wrote in message
...
Hi,

I have added the values(text) of 2 columns together by either eg.
=a1&""&a2
or =concatenate(a1,a2). I want to use the result of this as the
lookup_value
in a vlookup formula but get a #N/A error. Is it possible to use vlookup
in
such an instance? If so what can I do to make the formula work?


Thanks

Don't add/concatenate anything.
Simply use A1&A2 as the lookup value.

Bruno