i think this is what you mean.

example

""""""""""""""""SHEET1"""""""""""""""""""""
PERSON NAME
john 20
sarah 19
belinda 32
joesph 14
matt 15
homer 30
bart 12
maggie 1
lisa 10
marge 30

"""""""""""""""SHEET2""""""""""""""""""""""

put this code in the cell

=VLOOKUP("bart",A1:B20,1,FALSE)

then in the cell next to it

=VLOOKUP("bart",A1:B20,2,FALSE)

"""""""""""""""""""""""""""""""""""""""""""""" ""
LINE 1
what it does is lookups bart in the range A1:B20 returns the column 1
value

LINE 2
what it does is lookups bart in the range A1:B20 returns the column 2
value

to get a better understanding click the cell you want it to go in and
click INSERT FUNCTION VLOOKUP and go through the steps


hope this helps


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549358