Help Please
I can hide part of a formula with Text(a1,";;;") but then I can’t use vlookup,
i have a long concatenation
=(text(AP4,“ddd dd mmm”))&" “&AQ4&” “&AR4&” “&AS4&” “&AT4&” “&AU4&” “&AV4&” "&AO4
I can hide the output of AO4 whch is a reference for a vlookup by Text(AO4,";;;") but then i can’t use that out put as a reference as in
=VLOOKUP(RIGHT(B3,3),BC2:BE80,2,0)
I thought of changing the colour of of that part to white but but I cant find out how to do it.
Thanks
Gerry