Forum Discussion
Solved
Formula or Function???
I have an excel spreadsheet that is huge (over 400 names and over 30 courses) and I need an easy way for a person to see their specific course requirements. Not sure if they would click on their name...
=IFERROR(INDEX($AG$16:$BQ$16,SMALL(IF(OFFSET($G$1,MATCH($BU$21,$G$23:$G$435,0)+21,26,1,37)=1,COLUMN($A:$AK)),ROW(1:1))),"")You are welcome. You can try this formula which works in my file. The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.
Thanks for reply Lz but for some reason even on example I am getting error and returning either blank or #NAME? response for anyone other than Johnson. I love the idea of a separate sheet though. Much easier for personnel then my huge spreadsheet. My table is much more complex then just those simple headers and the headers are not even in same row. Unfortunately it was a sheet not originally designed by me. My names are in G23 to G435 and my course title headers are in AG16 to BQ16. Not sure if even adaptable to the formula you wrote?
Thanks again for you time! If you have other ideas I'm open!
Alicia
Thanks again for you time! If you have other ideas I'm open!
Alicia
My table is much more complex then just those simple headers and the headers are not even in same row. Unfortunately it was a sheet not originally designed by me. My names are in G23 to G435 and my course title headers are in AG16 to BQ16
This looks to be an "interesting" setup. Could you please:
- Share a representative workbook (replace actual names with Name1, Name2...) i.e. https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07 or any other file sharing service
- Clarify which version of Excel you run