You overwhelmed us with information ! <g

Do you mean something like this:

=VLOOKUP(...)&VLOOKUP(...)&VLOOKUP(...)

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Hello,

Am I able to reference three cells using a vlookup?

i would like to join the cells similiar to a formula that uses &

Any help?

Thanks