on sheet 1

SO if you have this list
PERSON NAME
john 20
sarah 19
belinda 32
joesph 14
matt 15
homer 30
bart 12
maggie 1
lisa 10
marge 30


and sheet 2

you have the "input cell" as A1 and there "other value" as B1 enter
this formula into B1

=VLOOKUP(A1,Sheet2!A1:B20,2,FALSE)

is this better ?


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