I can hide part of a formula with Text(a1,";;;") but then I can't use vlookup

asked 2016-03-15 00:08:04 +0100

Greyghost60 gravatar image

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

edit retag flag offensive close merge delete