Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

Sorry, but it didn't work for me. Thanks

"pinmaster" wrote:

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

Hi,

Sorry the formula should be:

=INDEX(Sheet1!$B$2:$I$22,MATCH(A2,Sheet1!$A$2:$A$2 2,0),MATCH(B2,Sheet1!$B$1:$I$1,0))


HTH
Jean-Guy

"pgarcia" wrote:

Sorry, but it didn't work for me. Thanks

"pinmaster" wrote:

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

I get N/A. What could I be doing wrong? It would seem to work. Is it my
formating? I'm puting this in Sheet2, should it be in Sheet1?

"pinmaster" wrote:

Hi,

Sorry the formula should be:

=INDEX(Sheet1!$B$2:$I$22,MATCH(A2,Sheet1!$A$2:$A$2 2,0),MATCH(B2,Sheet1!$B$1:$I$1,0))


HTH
Jean-Guy

"pgarcia" wrote:

Sorry, but it didn't work for me. Thanks

"pinmaster" wrote:

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

Hi,

It could be your format if one set of dates is formatted as dates and the
other as text. Check that and also the spelling you might have extra spaces
somewhere.

If you want, you can email me a sample of your data to look at....


Regards!
Jean-Guy

"pgarcia" wrote:

I get N/A. What could I be doing wrong? It would seem to work. Is it my
formating? I'm puting this in Sheet2, should it be in Sheet1?

"pinmaster" wrote:

Hi,

Sorry the formula should be:

=INDEX(Sheet1!$B$2:$I$22,MATCH(A2,Sheet1!$A$2:$A$2 2,0),MATCH(B2,Sheet1!$B$1:$I$1,0))


HTH
Jean-Guy

"pgarcia" wrote:

Sorry, but it didn't work for me. Thanks

"pinmaster" wrote:

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check

OK, OK, so I'm a little slow. I got it to work and it works GREAT!!!!

Your the best!!!!!!!!!

"pgarcia" wrote:

I get N/A. What could I be doing wrong? It would seem to work. Is it my
formating? I'm puting this in Sheet2, should it be in Sheet1?

"pinmaster" wrote:

Hi,

Sorry the formula should be:

=INDEX(Sheet1!$B$2:$I$22,MATCH(A2,Sheet1!$A$2:$A$2 2,0),MATCH(B2,Sheet1!$B$1:$I$1,0))


HTH
Jean-Guy

"pgarcia" wrote:

Sorry, but it didn't work for me. Thanks

"pinmaster" wrote:

Hi,

Try something like this:

=INDEX(Sheet1!$A$2:$I$22,MATCH(A1,Sheet1!$A$1:$A$2 2,0),MATCH(B1,Sheet1!$B$2:$I$1,0))

copied down

HTH
Jean-Guy

"pgarcia" wrote:

Hopeful I can write this down.

Worksheet 1 = Cell A1 headers reads "Date", C1-I1 cell headers are numbers,
e.g. 32,31,33,614 etc. Then in A2-A22 is a date (1/2/07). B2-B22 is a name
and so is C2-I22.
DATE 32 31 33 614
1/2 Jackie Sean Tally Mezar
1/3 Sean Tally Jackie Mezar
1/4 Tally Jackie Sean Mezar
1/5 Jackie Sean Tally Mezar


Worksheet 2 = I have two columns. A1 and B1, the headers, A1 "Date" and B1
is "Payment" e.g. 33, 31, 33, 614 ect in the column. I would liked to (in
cell C2) retune the name of the person who is responsible for that Payment
for that date form worksheet 1. So it will look up the information in the
fist worksheet and return it in the other worksheet.
Deposit Date Payment Method Responsible
9-Jan-07 031 Check
11-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
17-Jan-07 031 Check
19-Jan-07 031 Check
19-Jan-07 031 Check