| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Linear Mode
