T
terri
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.
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.