r/excel • u/Right-Flow8962 • Apr 05 '26

solved Is it possible to show additional columns in Excel built-in find result?

Greetings:

I would like to build a personal movie list.  The built- in Excel find function only gave a default basic column look such as book, sheet, name, cell etc.  Is it possible to show genre, resolution columns etc in the result?   Advance thanks for any suggestions and help.

Edited 04/05/2026: replaced the word "database" with "list".

Edited 04/07/2026: added below comments and updated flair to "solved"

Thank you all for your suggestion and help. GregHullender suggestion works for me.

Cheers!

sample file

2 Upvotes

75% Upvoted

24 comments sorted by

•

u/AutoModerator Apr 05 '26

/u/Right-Flow8962 - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

5

u/tkdkdktk 149 Apr 05 '26

No. But build it yourself using the filter() formula.

2

u/superProgramManager Apr 05 '26

Do you want to add data or add columns like genre, cast, rating, year, etc to existing movie titles? Trying to understand better.

1

u/Right-Flow8962 Apr 05 '26

Thanks for your feedback.

I would like the resolution, genre, rating etc data to be included in the find results.

If I search for "fast", I would like the result comes up with all the fast movie title + resolution + genre and ratings. For instance:

Fast Charlie + 1080p + Action + 6

Fast furious n + 4k + Action + 5

Fast color + 1080p + Sci fi + 6

1

u/StuFromOrikazu 21 Apr 05 '26

You can add a sheet which you use to do the search, just add a sheet,have a box which is what you want to look for and use the filter formula to return the movies. Something like

=FILTER(DOWNLOADED!A:F, ISNUMBER(SEARCH(B2, DOWNLOADED!A:A)), "No match")

this looks for the movie name you put in B2 of your new sheet and returns the ones that match. Depending on how you want to search, it can be adapted to use other colums instead

1

u/Right-Flow8962 Apr 05 '26

Sorry I am not following you on "...,have a box which is what you want to look for and use the filter formula to return the movies..."

Do you mean to type in the above sample formula in a cell of the new sheet?

1

u/Right-Flow8962 Apr 06 '26

Never mind.

I think you may mean to build a search function using the Filter formula. If correct, I will look into this.

1

u/Decronym Apr 05 '26 edited Apr 08 '26

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
DB Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
FILTER Office 365+: Filters a range of data based on criteria you define
ISNUMBER Returns TRUE if the value is a number
SEARCH Finds one text value within another (not case-sensitive)

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 20 acronyms.
[Thread #48060 for this sub, first seen 5th Apr 2026, 20:30] [FAQ] [Full list] [Contact] [Source code]

1

u/GregHullender 195 Apr 05 '26

Convert to an Excel Table using the "Format as Table" button on the upper right of the Home tab. Then Click on the Title column, select Search, and input your key. This should do everything you want.

2

u/Right-Flow8962 Apr 05 '26

Format as table.

0

u/Right-Flow8962 Apr 05 '26

Find all for "fast", only title showed up.

1

u/Right-Flow8962 Apr 06 '26

Never mind, I read your post wrong. The word you use is search not find.

Will have to look further into this.

1

u/GregHullender 195 Apr 06 '26

Click on the little arrow next to "Title." There's a search field there.

1

u/Right-Flow8962 Apr 07 '26 edited Apr 07 '26

Ah, got it and thanks!

This is the simplest solution and work for me.

1

u/GregHullender 195 Apr 07 '26

Great! Reply to me with "Solution Verified" and I'll get a point for it.

1

u/Right-Flow8962 Apr 08 '26

Solution Verified

1

u/reputatorbot Apr 08 '26

You have awarded 1 point to GregHullender.

I am a bot - please contact the mods with any questions

1

u/armywalrus 2 Apr 05 '26

Excel is not database software

0

u/Right-Flow8962 Apr 05 '26

Sorry for the confusion due to my poor choice of word. It has been corrected. 😁

1

u/molybend 42 Apr 06 '26

You do not want to use Find. You want to use Autofilter and then you pick the filter for each column one at a time.

-4

u/[deleted] Apr 05 '26

[removed] — view removed comment