Hummm, short on info but perhaps use INDERECT on the concatenation cell in
your VLOOKUP...

VLOOKUP(INDERICT(A1),B1:C20,2,0)

where A1 has a formula something like this...

=D1&E1

HTH
Regards,
Howard

"M Thompson" wrote in message
...
Hi
I need to join the numbers from 2 cells so that I can use them in a
vlookup.
When I do a concatenation, then a paste special, values, the vlookup can't
use it. Any ideas?

Thanks and have...
--
OneFineDay