I need help with a match index formula at first. After this I am going to change the pathway by using Concatenate, so people can just copy and paste the rows and not have to manually enter a lot of information. -The formula is in the Example_2 workbook.
I was trying to use VLookup, but this is not going to work as ranges will constantly be changing and so forth.
Here is the code I have right now:
[code]
=IFERROR(INDEX('[XX2825_Document Schedule.xlsm]Master List & Hours'!$B$557:$UU$579,SMALL(INDEX((ROW('[XX2825_Document Schedule.xlsm]Master List & Hours'!$B$557:$UU$579)-ROW('[XX2825_Document Schedule.xlsm]Master List & Hours'!$B$1:$UW$1))+9^9*((ISERROR(MATCH('[XX2825_Document Schedule.xlsm]Master List & Hours'!$B$557:$UU$579,$D5,0))+('[XX2825_Document Schedule.xlsm]Master List & Hours'!$B$557:$UU$579=""))>0),0),1)),"")
[\code]
Attached are example workbooks for what I am trying to accomplish.
Thank you!!
Kirsten
Bookmarks