Hi!

One way:

=IF(COUNTIF(Sheet2!A1:A100,A1),SUMIF(Sheet2!A1:A10 0,A1,Sheet2!B1:B100),"")

Another way:

=IF(ISNA(MATCH(A1,Sheet2!A1:A100,0)),"",VLOOKUP(A1 ,Sheet2!A1:B100,2,0))

Or combine elements of both:

=IF(COUNTIF(Sheet2!A1:A100,A1),VLOOKUP(A1,Sheet2!A 1:B100,2,0),"")

Biff

"darkbearpooh1"
wrote in message
news:darkbearpooh1.22zwuy_1139544902.0626@excelfor um-nospam.com...

sure this has been asked before but wth =)

ok... trying to figure out if i create two work sheets one will have
something similiar to a person's name in one cell and a number of hours
they are working in another cell so say A1= John B1= 5

the other worksheet i want to lookup from the other worksheet if john
is on that worksheet and the number of hours beside his name thanks!


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510905