Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=MATCH with nested arrays assistance needed
I researched this topic at length today, and understand it for the most part. I customized it and received a result that was different than expected.
The objective of my spreadsheet is to comb through a worksheet containing raw data of completed courses. I have student IDs and course names. When I find a match, I want to assign a point value for having completed the course. I have created a sample.xls to demonstrate what I have done and where it is breaking down. This equation works well and I receive the desired outcome. In this case, there was a singular class name I was looking for in each cell. Code:
{=IF(ISERROR(INDEX(Completed_Courses_Raw_Data!$A:$A,MATCH(Calculated_Results!$A4&Calculated_Results!E$2,Completed_Courses_Raw_Data!$A:$A&Completed_Courses_Raw_Data!$B:$B,0))),0,Calculated_Results!E$3)} When I use this equation, I only return TRUE when the course name in the first cell is a match - and it appears to ignore the rest of the optional course names that could also trigger a TRUE. Code:
{=IF(ISERROR(INDEX(Completed_Courses_Raw_Data!A:A,MATCH(Calculated_Results!$A4&Courses_w_Multiple_Names!$A$2:$A$20,Completed_Courses_Raw_Data!$A:$A&Completed_Courses_Raw_Data!$B:$B,0))),0,Calculated_Results!$V$3)} Code:
Calculated_Results!E$2 Code:
Courses_w_Multiple_Names!$A$2:$A$20 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a match- should i use a nested array, my source arrays, or | Excel Programming | |||
Need assistance with COUNTIF while using multiple data arrays | Excel Worksheet Functions | |||
VBA Assistance Needed | Excel Discussion (Misc queries) | |||
Coding assistance needed. | Excel Programming | |||
Assistance Needed with Comparing | Excel Programming |