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

  • Hi again. Question and request - Q: why don't you fill in the model numbers and avoid the pain? Request: would you please edit your question and "SEARCH" spreadsheet to show how a successful outcome would appear in the event of a model being on multiple invoices.
    – Tedinoz
    Commented Jul 6, 2021 at 1:38
  • ok, I cant fill in the model numbers :( because im not the owner of the spreadsheet but thank you! Commented Jul 6, 2021 at 17:04

1 Answer 1


Here is one way:

    left(1 / len(B2:B); 0) 
      row('Hoja 1'!A2:A); 
      if( len('Hoja 1'!A2:A); { row('Hoja 1'!A2:A) \ 'Hoja 1'!A2:A } ); 
={ 'Hoja 1'!B2:B }
=iferror( filter(IMPORT!A2:A; len(IMPORT!B2:B); IMPORT!B2:B = B1) )

See your sample spreadsheet.

  • thank you! got it :) Commented Jul 6, 2021 at 17:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.