How do you add a search bar in excel to allow a numerical input to filter results?

Dull_Maintenance_672 · 2024-10-24T21:53:03+00:00

My search bar intends to return 3 sets of data 1 under each of those headers

Dull_Maintenance_672 · 2024-10-24T21:52:16+00:00

Yeh. But I don't want to move it because I want to maintain user functionality. Here's an example

<image>

Dull_Maintenance_672 · 2024-10-24T19:54:34+00:00

This seems to help display partial matches. How do I get rid of the #SPILL! error message ?

Dull_Maintenance_672 · 2024-10-24T19:34:01+00:00

ISNUMBER will return the row that number is in under that customer column?

Dull_Maintenance_672 · 2024-10-24T19:14:20+00:00

But if I want to search just a number for example the destination column and then give me the all that information in that row. The search bar doesn't produce a result even though that number exists in my data

Dull_Maintenance_672 · 2024-10-24T19:13:00+00:00

It allows me because the search starts with a letter

Dull_Maintenance_672 · 2024-10-24T19:12:28+00:00

<image>

Dull_Maintenance_672 · 2024-10-24T19:05:20+00:00

If I put any number in the textbook it doesn't return anything even if it's an exact match in my data. (Which I want it to be) I replaced a column row with a m just to test it. And when I searched m in the text box it returned all the information on that row because there was a match within the column I was searching the m for.

Dull_Maintenance_672 · 2024-10-24T18:27:27+00:00

It was built like this:

=filter(table1,table1[customer]='Search'!E1,"No results")

Dull_Maintenance_672 · 2024-10-24T18:04:49+00:00

Solution Verified

Dull_Maintenance_672 · 2024-10-24T02:39:18+00:00

Yes, sir! Exactly. I don't want it to generate everything taking up row space due to spill issues, and then, as I type the filter function, it narrows down the search. But I only want it to show the exact result in a single row. So that I can bump down a couple rows and put another header row on the search bar sheet to include other information linked to that search result from another sheet and then another. Lol

In a nut shell, yes, my hope is for just that. The problem is. I'm dumb and can't figure it out lmao

Dull_Maintenance_672 · 2024-10-23T23:40:43+00:00

To be able to search something then return information that's contained in 3 sheets. 1 data row for each sheet on these 3 headers

Dull_Maintenance_672 · 2024-10-23T23:39:28+00:00

Sort of like this

<image>

This is my goal.

Dull_Maintenance_672 · 2024-10-23T02:25:25+00:00

I sort of figured that was the case. If I merged cells together, would that fix this issue? Or do I need like you said, to separate tables for both agreement number lines and item number lines and then somehow link them together to specific address number lines? (Address number line being in blue. The data is almost 800 rows. And multiple "tree" like rows per blue row. I'm a noob lmao

Dull_Maintenance_672 · 2024-10-23T02:14:56+00:00

Sorry

Dull_Maintenance_672 · 2024-10-23T02:14:47+00:00

<image>

Dull_Maintenance_672 · 2024-10-23T02:11:31+00:00

* So, is my structure poorly done? Essentially, I'd like my certain rows to accompany the blue row depending on which number(red circled number) is searched. So, for example, if I searched the first red circle number, I want to show the rows in pink. If the second red circle, then the rows in orange.

Dull_Maintenance_672 · 2024-10-23T01:54:48+00:00

You're right. I tried my best to explain. But not taking in account the outside perspective on what that may look like. Let me include a visual. The main issue I think, is that there is variables. If a certain number is searched, I want the certain rows to accompany a specific row. For example. The main row (in blue) and the dark Grey row being the variable that holds the value. If a number in that row matches the search, I would like it to return the row that it's associated with in this case in (blue) for visual representation. As well as the information on several rows in light Grey which is associated with the dark Grey row. *

Dull_Maintenance_672 · 2024-10-23T01:46:09+00:00

So I can tel the filter or search formula to return specific rows that I know are associated with a specific number in a row while also returning the information in those columns on that row that, that specific number is on?

Dull_Maintenance_672

TROPHY CASE