Max...this worked fantastic! Thanks much. Can you give me some idea how
this forces it to a number?
--
OneFineDay


"Max" wrote:

Instead of using: =VLOOKUP(A1&B1,...,2,0)
try it as: =VLOOKUP((A1&B1)+0,...,2,0)
which coerces the concatenation lookup value to a real number
It should work ok now. Success? Click YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"M Thompson" wrote:
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?