I asked before how can.
"Find the previous non-blank value from a column using a value in an adjacent column as search key (https://webapps.stackexchange.com/questions/155482/find-the-previous-non-blank-value-from-a-column-using-a-value-in-an-adjacent-col)" this is my sample spreadsheets https://docs.google.com/spreadsheets/d/1iefvYAg96rV16c6ARFrd5V5WZKU_j70JZzQn1tD0568/edit?usp=sharing
here is the source sheet and here is the search sheet https://docs.google.com/spreadsheets/d/1TvQHDeW8yMJVCeXrzWGYGDMY0wGEDBd_fIzISMZZ-Rw/edit?usp=sharing
It works fine but when the model repeats it just appeared the first choice or " no found"
how can i search one model and if it repeats to find all the matches(invoices) and all the matches to be in a drop-down list? if its too hard maybe can give me a clue so i can investigate it how to do it! :D thanks!! xoxo