Excel Sorting Issue

I have a workbook with a column that references another sheets using the index function. The "validation" sheet looks at an account number that is in one column (D) and pulls the matching vendor from...