I am using the Index> Match Function to show items on a new sheet on the basis of "Y" being entered into an adjacent column (images attached). My problem is that, if there are spaces or "N" rather than "Y" in that column, my new page produced the same number of duplicate values as the spaces in between. For example, N323 in the Master Sheet is checked "Y", but there are 5 rows above it that have values other than "Y"; therefore, there are 6 total copies of the corresponding "PB 7'-11'" value in the next sheet.
My formula is (example using cell A322): =INDEX(MASTER!A324:N1084,MATCH("Y",MASTER!N324:N1084,0),1)
Does anyone know how to fix this?
Reference Page.PNG
Output Page.PNG
Bookmarks