Multi-Step problem - text box input with output and a conditional formatting challenge

[BB38]

Hi -

I have a database with Column B being 500 or so unique names.

I have created a text box where I can input the name and the output will be the row in which the name is found. The formula I have used for this is: =IFERROR(MATCH(F8 & "*",Table2[Investor],0), "Not Found") +10

Now I want to add another feature:

I want the output to stay as it is but:

1. If there are multiple outputs for the same letters (for example, if there are 10 names that start with AD in column B) then I want the output to show me all the lines these are found on (right now the output can only show me one line number)

2. I want to have whatever the output is in #1 above - to then highlight the cells in Column B

Please let me know if I can expand further

BB

 

[Fluff]

Glad to help & thanks for the feedback.

 

[BB38]

This formula has worked fantastic. Taking it one step further.

Here's the current formula:

=TEXTJOIN(", ",,FILTER(ROW(Table2[Investor]),LEFT(Table2[Investor],LEN(F8))=F8))

How can I have the spreadsheet take me to the output row from this formula instead of having to scroll to it. Is that possible?

 

[Fluff]

Not sure if that's possible as it can return more than one row number, but as it's a totally different question, you will need to start a new thread.

 

[BB38]

Not sure if that's possible as it can return more than one row number, but as it's a totally different question, you will need to start a new thread.

no problem - thank you !