It sounds like you need a table (could also be on that other sheet in the same workbook) where your first column (A) is numbers from 1 through XX and the second column (B) contains the text you want to have appear. Then use =VLOOKUP([cell w number}),Sheet2!A1:Bxx,2,0)
But how are they to know what number to enter? Asked another way, could you describe the full scenario here; there is no doubt a way to accomplish this, but it's not clear to me, at any rate, what exactly you're trying to accomplish with the steps you've articulated. What's the "bigger picture"?
