search

My boss wanted me to create a search tool to assist our staff in locating relevant instructions, directives, etc. Below is the table I created wherein the user will enter one or more criteria to match. Based upon the criterion provided, Excel goes to the data source finds all the matching rows...

In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c). So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s)...

Hey all, Yesterday, we created this formula and it works well. I now need to be able to filter the returned results by a date range. I have put the start date in D5 and end date in E5. I have tried several different approaches and can't seem to get it right. I have a feeling I am on the right...

I have read no less than 50+ help articles, watched at least that many tutorials and scrubbed the posts here for any insights, but can't seem to find precisely what I am looking for. I have a spreadsheet tracking issues/tasks (range A7:AZ1005). In cell $Q$1 the user can enter a word to search...

Hiya All, I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present. =SEARCH("Aston",$G1) The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury. Is there a way to stop this? Thanks in...

Hello , im kind of stuck , I want to find the dates or the numbers of visits of a person In sheet 1 "B2" I can put the name of the person registered , and then in "F3" and downwards it shows me the dates the person was visited , or the number of visits (lets say visit 1 , 2, or 3) In sheet 2 ...

Hello! I made an application that will help compare various price lists of various suppliers with a master product list by product name. It often happens that in various price lists of suppliers there is no universal unique product key and you have to manually compare the name with your own...

Hi, I'm struggling to figure out why this formula wont work, thought this would be an easy one for me! I have a quarterly budget against business unit projects, several projects per business unit that I want to summarise. Q1 to Q4 budgets for each project listed in columns L to O. The criteria...

Hiyall, I've been working on a dynamic search bar in Excel, following this video, and it works fine. The formula is : =IF(I3="","Rien trouvé",FILTER(Table1,ISNUMBER(SEARCH(I3,Table1[Sujet])),"Rien trouvé")) Or with proper typo : =IF(I3="","No...

Hiyall, I've been trying to create a custom search bar and this video explaining it rather well. However, when it comes to the partial research, it appears that my version of Excel doesn't understand the [FIRST] variable (it's a Pro version 2021 - I thought it was enough, but maybe it needs...

I have a data set that includes alternate SKU's for products. The alternate SKU's may be in any one of 31 different columns. I have a list of alternate SKU's that I want to look for i the range. When found, I want the formula to return the corresponding value in a different column. This will be...

Hello, I need help with the following please. We get reports with hundreds of lines and I need to verify the error descriptions to catalogue and process errors. Only problem is the criteria is very specific and appears at different parts of string within the cell. Please see image attached to...

Hello excel experts, I need your help with the following: I have a range named "Database" with about 5000 entries and growing, on the same worksheet I have a small calendar that populates tasks according to the current month and date from the database, this calendar places items for each date...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

I've been working all day to no avail. Not sure why table is not filtering when activating this macro. Option Explicit Sub AgentFilter() Dim aQuery As String Dim LastRow As Long With sh_AGENTS LastRow = .Range("C999999999").End(xlUp).Row If...

Hi, I am looking a formula to search a table say D and 5 to return "Red" if someone could help please.

How to change Spreadsheet search (find) results cell border colour ? Seems so easy, but just cannot find anywhere that shows you. Excel 365 currently shows dark green, but with my eyes and screen colours, it looks very similar to the black of the grid lines.

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hello, good day everyone, I want to search based on the combobox as (search column) and textbox in sheet 1. How is this possible? ABCDEFGH1no.Nameidsexagedate of birthIQ TestMeaning of Name214Ani4935426663female2231/10/199998Ornament, Beautiful, Variant of Anne /...

Hi, I requrie a formula in sheet 2 cell AW2 through to AW99 to search using the data shown in Sheet 2 Cell A2 (to A99 as it will repeat on each row) This will then search for the same data in Sheet 1 Cell C2 to C99, and return the first occurance of the value shown within Column N that matches...