Not sure what you exactly want but this may point you in some sort of a
direction:
If say the something you wanted to look up in Sheet 1 was names and dates in
cells A1 to B6:
names ages
fred 23
ada 76
jane 42
jack 36
jill 24
and in your new worksheet (Sheet2) you entered the name of the person you
wanted to find the age for in A1; say
Jane. Then in cell B1 on Sheet 2 enter the following formula:
=VLOOKUP(A1,Sheet1!A1:B6,2,FALSE)
you will see that the answer in B1 is 42.
Now if you change the name in Cell A1 on Sheet2, you will see the age change
accordingly
Hope this helps
Philip