ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Look up formula, multiple cells (https://www.excelbanter.com/excel-discussion-misc-queries/127943-look-up-formula-multiple-cells.html)

pgarcia
Look up formula, multiple cells
 
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

pinmaster
Look up formula, multiple cells
 
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

pgarcia
Look up formula, multiple cells
 
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

pinmaster
Look up formula, multiple cells
 
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

pgarcia
Look up formula, multiple cells
 
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

pinmaster
Look up formula, multiple cells
 
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

pgarcia
Look up formula, multiple cells
 
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

pgarcia
Look up formula, multiple cells
 
Great, right you are. Sorry for the trouble. I'm a little slow some times.

"pinmaster" wrote:

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

pinmaster
Look up formula, multiple cells
 
Excellent......glad I could help and thanks for the feedback!

Best Regards!
Jean-Guy

"pgarcia" wrote:

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


All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com