Gurus please help!
The FeePage sheet is a summary page that pulls data from the Master sheet using formulas. All I do is enter the CRN number into column A on the FeePage and the rest of the row is populated with the data. Some classes have more than 1 row in the master sheet. For CRN 20570 the class days are S, U & F. The formula I have just pulls the class day value from the first row and then stops.
How can this formula be reworked to loop through the matching rows and give the desired result of "FSU"=IFERROR(VLOOKUP(TEXT($A3,"0"),Master!$1:$10001,COLUMN(),FALSE),IFERROR(VLOOKUP($A3,Master!$1:$10001,COLUMN(),FALSE),""))
Many thanks!!!
NeedAllDays.xlsm
Bookmarks