Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be.
Scenario:
I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on that sheet to combine the job number and the job name into one text strinng on in another column.
=[MBC Project #1]@row + " " + [MBC Project Name]@row
I then have another column which lists all active projects based on the "active column" being checked.
=IF([Active?]@row = 1, [Project # / Name w/ Description]@row, "No")
on the sheet with the index match formula, I have a drop down which permits selection of the "active projects".
Everything up through here works correctly. However, I am using the following formula in an attempt to assign the supers name based on the drop-down project selection column/row.
=INDEX({MBC Project List Project # / Name Helper}, MATCH([Project # / Name]@row, {MBC Project List Super / FM Name}, 0))
Can anyone help me resolve the issue? I can't seem to figure it out.
