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