Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH and OFFSET
Hello,
I have three sheets in a workbook. The first sheet contains a project plan from MS Project, the second sheet contains the same Project Plan, except updated by Project Managers. Here is where the fun begins. In the third sheet I'm trying to do a MATCH from sheet 2 to sheet 1. But have the rest of the values in the row move over to the third sheet as well. I'm able to match no problem except it give me a "2" instead of the task name (which is what MATCH does), but is there a way to I can use MATCH and OFFSET to bring over the entire row? I basically want to get variances in start and finish dates, complete %, etc. between the two plans. Any help at all would be much appricated!! Thanks in advance! Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH and OFFSET
Hi!
Match returns a values relative position in an array. Use the Index function in conjunction with Match to return the actual value: =INDEX(A1:A10,MATCH(.........................)) If as you say: "I'm able to match no problem except it give me a "2" instead of the task name" In the above formula "Match 2" would return the value in A2. If you want additional data from the same row just drag copy the formula across and the Indexed range will increment to B1:B10, C1:C10, etc. Biff wrote in message ups.com... Hello, I have three sheets in a workbook. The first sheet contains a project plan from MS Project, the second sheet contains the same Project Plan, except updated by Project Managers. Here is where the fun begins. In the third sheet I'm trying to do a MATCH from sheet 2 to sheet 1. But have the rest of the values in the row move over to the third sheet as well. I'm able to match no problem except it give me a "2" instead of the task name (which is what MATCH does), but is there a way to I can use MATCH and OFFSET to bring over the entire row? I basically want to get variances in start and finish dates, complete %, etc. between the two plans. Any help at all would be much appricated!! Thanks in advance! Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH and OFFSET
Thanks - I figure it out! I got rid of OFFSET and used INDEX instead -
works great! Thanks, Dave Biff wrote: Hi! Match returns a values relative position in an array. Use the Index function in conjunction with Match to return the actual value: =INDEX(A1:A10,MATCH(.........................)) If as you say: "I'm able to match no problem except it give me a "2" instead of the task name" In the above formula "Match 2" would return the value in A2. If you want additional data from the same row just drag copy the formula across and the Indexed range will increment to B1:B10, C1:C10, etc. Biff wrote in message ups.com... Hello, I have three sheets in a workbook. The first sheet contains a project plan from MS Project, the second sheet contains the same Project Plan, except updated by Project Managers. Here is where the fun begins. In the third sheet I'm trying to do a MATCH from sheet 2 to sheet 1. But have the rest of the values in the row move over to the third sheet as well. I'm able to match no problem except it give me a "2" instead of the task name (which is what MATCH does), but is there a way to I can use MATCH and OFFSET to bring over the entire row? I basically want to get variances in start and finish dates, complete %, etc. between the two plans. Any help at all would be much appricated!! Thanks in advance! Dave |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH and OFFSET
You're welcome!
Biff wrote in message ups.com... Thanks - I figure it out! I got rid of OFFSET and used INDEX instead - works great! Thanks, Dave Biff wrote: Hi! Match returns a values relative position in an array. Use the Index function in conjunction with Match to return the actual value: =INDEX(A1:A10,MATCH(.........................)) If as you say: "I'm able to match no problem except it give me a "2" instead of the task name" In the above formula "Match 2" would return the value in A2. If you want additional data from the same row just drag copy the formula across and the Indexed range will increment to B1:B10, C1:C10, etc. Biff wrote in message ups.com... Hello, I have three sheets in a workbook. The first sheet contains a project plan from MS Project, the second sheet contains the same Project Plan, except updated by Project Managers. Here is where the fun begins. In the third sheet I'm trying to do a MATCH from sheet 2 to sheet 1. But have the rest of the values in the row move over to the third sheet as well. I'm able to match no problem except it give me a "2" instead of the task name (which is what MATCH does), but is there a way to I can use MATCH and OFFSET to bring over the entire row? I basically want to get variances in start and finish dates, complete %, etc. between the two plans. Any help at all would be much appricated!! Thanks in advance! Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match & Offset | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Index - Offset - Match Issues | Excel Worksheet Functions | |||
Formula Help With MATCH & OFFSET | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |