Formula to lookup a value in a row on a spreadsheet that matches name and date

[jsclark]

Hello! I am looking for help with a formula which will return a value from a worksheet based on the name and date in the current worksheet. So if Sheet1!Name = Sheet2!Name and Sheet1!Date = Sheet2!Date, then return Sheet1!Hours. Can someone please help? Thank you! Jenn

[jsclark]

To clarify:
Sheet1:
b5 = name
d4 = date

Sheet2:
b2 = name
x1:id1 = dates
x2:id2 = value

Need to lookup Sheet1!B5 on Sheet2!B2 and where the Sheet1!D4 date matches the date in the range Sheet2!x1:id1 return the corresponding value in Sheet2!x2:id2. I hope this helps. Thank you!

[FDibbins]

It would be easier if you supplied a sample workbook, but giv this a try...

=if(and(Sheet1!Name=Sheet2!Name,Sheet1!Date=Sheet2!Date),Sheet1!Hours,"")

[jsclark]

That worked great! Thank you so much and next time I will load a sample.

[FDibbins]

You'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, (see point 2 below)

[jsclark]

It appears only to work where the first date on Sheet2 is the same as the first date on Sheet1. I can't see to figure out how to attach a sample. THANK YOU!
Here is what I have loaded

A B C D
1 Employee Name 12/1/2012 1/1/2013 2/1/2013 3/1/2013 4/1/2013 5/1/2013 6/1/2013 7/1/2013 8/1/2013
1 First =IF(AND(Sheet1!$B$2=Sheet2!$B$2,Sheet1!$C$1:$T$1=Sheet2!C1),Sheet1!$C$2:$T$2,"")

Sheet 1:
A B C D
10/1/2012 11/1/2012 12/1/2012 1/1/2013 2/1/2013 3/1/2013 4/1/2013 5/1/2013 6/1/2013 7/1/2013 8/1/2013 9/1/2013
First 59.00 59.00 59.00 59.00 59.00 59.00 59.00 59.00 - 47.75 193.75 237.40

Any help you can provide would be great!

[FDibbins]

It appears only to work where the first date on Sheet2 is the same as the first date on Sheet1

Thats exactly what you asked for?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[FDibbins]

Try this in C2, copied down and across...
=INDEX(Sheet1!$B$1:$T$2,MATCH(Sheet2!$B2,Sheet1!$B$1:$B$2,0),MATCH(Sheet2!C$1,Sheet1!$B$1:$T$1,0))

Having seen your file, what you initially requested is not (I think) what you actually need

[jsclark]

And SOLVED! Thank you!