hidden values
 

i would like to have invisible and visible values in the same cell, is this
possible. then if this is possible i would like to enter a number in sheet
one which will do a vlookup kind of function and then show me the hidden
value in a different cell in sheet 1. sorry if i have not explained this very
well

many thanks

hidden values
 

A cell can contain one value
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rob" wrote in message
...
i would like to have invisible and visible values in the same cell, is this
possible. then if this is possible i would like to enter a number in sheet
one which will do a vlookup kind of function and then show me the hidden
value in a different cell in sheet 1. sorry if i have not explained this
very
well

many thanks