software

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: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905Hi!

One way:

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

Another way:

=IF(ISNA(MATCH(A1,Sheet2!A1:A100,0)),quot;quot;,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),quot;quot;)

Biff

quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.22zwuy_1139544902.0626@excelfor um-nospam.com...
gt;
gt; sure this has been asked before but wth =)
gt;
gt; ok... trying to figure out if i create two work sheets one will have
gt; something similiar to a person's name in one cell and a number of hours
gt; they are working in another cell so say A1= John B1= 5
gt;
gt; the other worksheet i want to lookup from the other worksheet if john
gt; is on that worksheet and the number of hours beside his name thanks!
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=510905
gt;

still can't quite get it to work could you explain how each part of the
formula works...
i only need the second sheet to tell me if a person't name is on the
first sheet and the hours they work and if the name isn't on the first
sheet then can = 0 or blank thanks--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905Ok, can you provide a more detailed explanation? Be very specific.

Biff

quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.23198o_1139607610.1318@excelfor um-nospam.com...
gt;
gt; still can't quite get it to work could you explain how each part of the
gt; formula works...
gt; i only need the second sheet to tell me if a person't name is on the
gt; first sheet and the hours they work and if the name isn't on the first
gt; sheet then can = 0 or blank thanks
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=510905
gt;

sure ill try to explain it better thanks for the help..

ok my excel project is broken down into several sheets
monday tuesday wednesday ect for every day of the week
each day has a person's name in a cell say cell A1=bob
A2=mary ect.

beside them in cell B1 is how many hours they work so we have cell
A1=Bob Cell B1=6.5 for 6 and a half hours he worked

ok... now thats several sheets monday, tues, wednesday ect some
might have the person's name if they work monday some might not
if they are not working...
the final sheet i want to make i have columns for each day monday tues
ect..
and i am putting all employees names in say A1-A30 for howevermany
people are on staff column B will be monday column C Tues ect...

now down column B which is for monday i want it to check the monday
sheet i have made and if the person's name is on monday sheet give me
the amount of hours they work that day which is in a different cell if
possible... thanks--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905Ok.

Based on your explanation any of the formulas I suggested will do what you
want.

I can put together a sample file that demonstrates this, or, this would be
even better, if you could post a sample file so I could see EXACTLY how your
file is setup.

It's kind of slow here tonight and I'm looking for a good project to do.

Biff

quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.231mfm_1139624701.699@excelforu m-nospam.com...
gt;
gt; sure ill try to explain it better thanks for the help..
gt;
gt; ok my excel project is broken down into several sheets
gt; monday tuesday wednesday ect for every day of the week
gt; each day has a person's name in a cell say cell A1=bob
gt; A2=mary ect.
gt;
gt; beside them in cell B1 is how many hours they work so we have cell
gt; A1=Bob Cell B1=6.5 for 6 and a half hours he worked
gt;
gt; ok... now thats several sheets monday, tues, wednesday ect some
gt; might have the person's name if they work monday some might not
gt; if they are not working...
gt; the final sheet i want to make i have columns for each day monday tues
gt; ect..
gt; and i am putting all employees names in say A1-A30 for howevermany
gt; people are on staff column B will be monday column C Tues ect...
gt;
gt; now down column B which is for monday i want it to check the monday
gt; sheet i have made and if the person's name is on monday sheet give me
gt; the amount of hours they work that day which is in a different cell if
gt; possible... thanks
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=510905
gt;

great how can i post the file? i don't see a excel file format--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905You can zip it and then post a zip file (*.zip)

Biff

quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.231voy_1139636701.3881@excelfor um-nospam.com...
gt;
gt; great how can i post the file? i don't see a excel file format
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=510905
gt;

hmm can you im me on aim? (darkbearpooh1) might be quicker that way ..
because my file is kinda complex and complicated so i could explain it
more if not i am looking for a program to zip the file--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905
im wimping out because i have to be in to work in a few hours so i
figure i should get some sleep .. lol so if you want you could just
post your example i can figure it out from there thanks soooo much for
the help--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=510905