Look up formula, multiple cells

[Guest]

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

 

[Guest]

Hi,

Try something like this:

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

copied down

HTH
Jean-Guy

 

[Guest]

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

Hi,

Try something like this:

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

copied down

HTH
Jean-Guy

 

[Guest]

Hi,

Sorry the formula should be:

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


HTH
Jean-Guy

 

[Guest]

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?

 

[Guest]

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....
(e-mail address removed)

Regards!
Jean-Guy

 

[Guest]

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

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

 

[Guest]

Great, right you are. Sorry for the trouble. I'm a little slow some times.

 

[Guest]

Excellent......glad I could help and thanks for the feedback!

Best Regards!
Jean-Guy