I would like to search using name and training then display all the results horizontally below the date heading.
If I pick Name: AP (from cell C3) and Training: Basic Site Walkover / Feature Identification (from cell E6) I want to show the month and year that the training was completed in cells F6:I6.
In F6
=IFERROR(INDEX(database!$H$7:$ZZ$7,,MATCH($E6,OFFSET(database!$H$7,MATCH($C$3,database!$B$8:$B$14,0),,,COLUMNS($H:$ZZ)),0)),"")
Unmerge date cells in row 7: avoid using merged cells whenever they are to used in any formula.
Changed "piting" to "Pitting" in your lists.
Last edited by JohnTopley; 04-14-2016 at 06:35 AM.
Great Thank-you this works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks