I have made this formula work in the past but I can't seem to figure out why it is not working now.
To preface, I have to create a vlookup to determine a parent_ID Number. Example is I have a parent ID of 923, but I have a subset that fall under 923 like 909, 915, 918, so on. I have to have 2 columns, one for Parent Origin and one for Parent Destination.
I want to have a unique list of trailers based on the criteria on my main page where I reference D1, D2, and D3.
Right now I am getting a #N/A as a result and I think I have routed it to my vlookup columns but I am not sure why that is impacting my Index formula.
=INDEX('Trailers Closed (OD)'!B:B,SMALL(IF(($D$1='Trailers Closed (OD)'!M:M)($D$2='Trailers Closed (OD)'!Y:Y)($D$3='Trailers Closed (OD)'!Z:Z),ROW('Trailers Closed (OD)'!B:B)),ROW(A1))-1,1)
This is my data sheet.
123.png
This is my main sheet where I am trying to generate the list of trailers.
345.png
Bookmarks