search a range

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...

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 am new to Excel and my brain is fried from trying to search the forum for similar questions/answers. I am trying to populate a column with data based on information from 2 other columns. In the attached worksheet, I want to populate column E with the names of the clients based on...

=XLOOKUP([@Item]&[@[Bin Number]],Item19&Bin_Number19,"@[Count19]","",1) =XLOOKUP("[@Item]='R19'!@Item19*'Calculate sheet'!@[Bin Number]=@'R19'!A3:A68",Item19,Count19,"",1) this only pulled the first instance of the same name I tried the above and a few other variations but could not get the...

I need a formula that in column F will search and match a table where Column I's value is within Column A and make F egual to the equivalent value in J. I've tried search, match and Vlookup to no luck. Eg, I2 is within A2 so B2 should equal to J2 I3 is within A5 so B5 should equal to J3

Hi guys, Need help with the formula below. What I need it to do is search through the workbook sheets (2-101) and check on each sheet if cell "D1" shows a result of TRUE or FALSE. If it is TRUE, then I need the formula to change the contents of cell "E6" on that sheet to read the current date...

Hey Guys, I am trying to build sort of a database with a search in it. So, what i am trying to do is: When user enters a text in C7 and hit the button, it searches the text (exact match) in Sheet2(called Data) then displays it in Cell C19. Attached screenshots for more clarity. Thanks a lot in...

Right now, my code searched for "MI (D)" in column "B" and adds 4 additional lines at the bottom of the code dependent on what State is next to that value in column "A". However, there are some instances where there are many "MI (D)" combinations, so the code cycles through each one and adds...

Hello, I wanted to find the value I want among the one thousand data in Excel Sheet and I used binary search algorithm it doesn't work for me. Then, I got some errors so I simply rearrange the problem to be understandable more. I would be grateful if you could write the code for the following...

Hello! I need some help. I am currently an intern in a company and my boss asked me to make a Excel file to keep an overview of there ordering materials list. i want an front page that the individual employee can post information in and then be redirected to the specific colloum containing...

Hi all I have this data with columns: - A: the ID of the product - B: the start of the proces - C: the end of te proces - D: the state of the proces during B to C ID Start End State 10028700 1/01/2020 31/03/2021 Active 10028700 1/04/2021 31/12/9999 Inactive 10029917 1/07/2021...

Hi Everyone! I am a beginner to macros and just received help on another question here. I would like to adjust the code however, and have been struggling a lot. I just wrote a macro which compiles data from different workbooks into one compiled data workbook. This compiled data is structured as...

Hi everyone, I am trying to figure out a macro in excel that would search for a specific value and jump to that point in a specific word file. As an example: Cell A1 has the value "Company X" in it. I would like to be able to press Cell A1 and the code then opens the word document and jumps...

Does anyone have any idea why this code only searches the first row with a matching header instead of every row with a matching header? =COUNTIF(INDEX($A$4:$F$360,MATCH(LEFT(L$4,3),LEFT($A$4:$A$360,3),0),0),$J16&", "&LEFT($K16,1))+N16 Array $A$4:$F$360 with header $A$4:$A$360,3 trying to...

Hi everyone, I am trying to extract data from a website using VBA. This is the web site: https://gmsip.com.pa But i can not add my range of data to search bar is there any solution to this problem ? no i want to add IMO numbers for ship in the excel sheet and VBA run them in website and...

Hello, I have a table with a list of Keywords. I also have a list of Item Descriptions. I am trying to figure out how to count the number of times any of the keywords from the list are mentioned in each item description. For random example: <tbody> A B C D E F G H I J K L M N...

Hi All, Have a worksheet with a lot of data and I'm building a search VBA that hides/unhides columns based on 2 cells containing user entered data (from drop down menus). The first "For" function works without a problem, its easy since it's reading from a range with a single row, the second...

I need to determine if the individual cells in column A (A1:A17933) contain text from any of the cells in column C (C1:C1957), and if so, return the column C cell's corresponding value in column D (D1:D1957) to the column B cell next to the column A cell containing the column C cell text. For...

Hi, I want to click macro. it searches sheet3 A:A for a value. If it doesnt find it, message just says value not present. If it finds it, it pulls up a userform named "goahead", it consists of three choices yes, no, n/a. whichever one is selected, it places that in sheet3 column z for that...

Hello to all, I want to search the substring within a range that is not in a single row and if match select the cells where is the string present. I was able to make a code that works but only if the data is in a single row, but I don't know how to do it if the data is in a range with several...