I have a 3 column table, one with the Order Number, one with Notes, and one with the # of characters in the notes.
Each order can have multiple notes that i am concatenating from another table. For example:
A123 note1, note2, note3
A123 note1, note2
A123 note1
I sort these by amount of characters which would make A1233 go to the top. When I vlookup A123 I want it to return the one with all the notes combined(the one towards the top with the most characters.) For the most part it does work by doing this, but sometimes it will return the 2nd or 3rd one within the list. Thanks.
Each order can have multiple notes that i am concatenating from another table. For example:
A123 note1, note2, note3
A123 note1, note2
A123 note1
I sort these by amount of characters which would make A1233 go to the top. When I vlookup A123 I want it to return the one with all the notes combined(the one towards the top with the most characters.) For the most part it does work by doing this, but sometimes it will return the 2nd or 3rd one within the list. Thanks.