I have a several column range that shows classes matched up in the same row with the date the class is held. In another column I have a straight list of the class names that I then want to show the dates that each class has class in the adjacent four columns. Also the class name cannot be matched exactly because the class names in the range have variations in the text that follows the class name. The attached workbook shows a formula that works in Sheet 1 for almost the identical situation but didn't work in Sheet 2 even when matching the whole class name as given in the adjacent cell.
IndexMatchArrayfromRange.xls
Bookmarks