I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have
a number.

In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure
it's because of the lookup, but I really don't want to change my lookup to a
value.

Is there anyway to get around it?

Thanks.