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 a the "AV Match" sheet into another column (A). I am trying to sort the "validation" sheet based on column A, but when I do, the rows do not stay together, so that the account number and vendor are now in separate rows. Also, only one or two rows will stay at the top, then there will be a gap of about 50 blank rows, below that are rows that only consist of the vendor names that are in column A, then below that is all of the information that is in the rest of the columns. Can someone please explain why this might be happening or at least how to fix it?
