You can try the concatenation within the formula itself
VLOOKUP(A1&B1,...,)
--
If this post helps click Yes
---------------
Jacob Skaria


"M Thompson" wrote:

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