1

Im trying to get all values (in this case strings) from a column A which have a "house" in it via an array and put the results in column B started with cell B1. With vlookup I only get one result:

=SVERWEIS("*"&"house"&"*";A:A;1;FALSCH)

enter image description here

Improve this question
5
  • Please see How to Ask a question with an minimal reproducible example and edit in more relevant information to reproduce what you are trying. Include your own attempt (no matter how poor). Commented Jul 24, 2020 at 9:59
  • Sry – i edited it. Now better? :) Commented Jul 24, 2020 at 10:35
  • sample data would be very helpfull. Even a screenshot if possible. Commented Jul 24, 2020 at 10:38
  • 1
    ok, cool. now better? do you have a solution for me ;) Commented Jul 24, 2020 at 10:46
  • Yes, see the answer below. However, that screenshot is Google Spreadsheets. You sure you want Excel tagged? Commented Jul 24, 2020 at 10:50

1 Answer 1

Reset to default
1

You may use (having Excel O365)

=FILTER(A2:A9,ISNUMBER(SEARCH("*house*",A2:A9)))

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Ah cool, thank you! I convert the formula into spreadsheet and it worked. Thank you!

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.