index + search

tried wholeday to solve this problem. i need to match partial text from 'title' and meet a condition 'chn' column and bring value from the index column the current formula im using couldnt add an additional condition to look into chn column, also the partial matching of text in some cases is...

Hi everyone, I don't think I can explain what I'm looking for, but I will do my best. CRITERIA: If Cell A1 equals 1 of 50 states AND Cell A2 equals 1 of 3 Worker Categories AND Cell A3 equals a 1 of 2 FLSA types AND Cell A4 equals a 1 of 200 jobs THEN A5 equals 1 of 7 Pay Classes Example...

On the "List" worksheet, I have an inventory of Food, Music, Activity and Color that a Customer uses listed into columns. On a "Search" worksheet I have created PickLists cataloguing the Food, Music, Activity and Color available for Customers. My goal with this is to create an INDEX formula for...

Hi, I would like to search for Item 001, I need the search to be carried out on multiple sheets. Then, the results will be displayed in tables including the other related information. I watched several videos but still had errors in my excel: Currently i'm still searching information from 1...

This is a sample of a worksheet that has hundreds of countries and thousands of charges listed. Rather than having to scroll across and see each country that has charges, I need a formula that returns only the countries that have charges: <tbody> Charge Countries Argentina China France USA...

hi, I am trying to do an index match for 2 criteria. Lets say i have to return a random number from column C. Matching criteria 1 is DEF and matching criteria 2 is 01/11/2021 (I'd like to match the closest date). So ideally I would return Random(6). A B C ABC 01/01/2020...

Hi all I have a populated data base where each row represents a customer, and each column represents a product. Some columns are subdivided where a product has variants. All I want to do is create a simple worksheet where a product can be selected from a drop down list, and then all the...

Dear, I would like some help on the formulation of a formula in Excel in order to compare the total number of search results upon using different sets of separator characters. As I have multiple columns with content, as in the example below, I thought it would be possible to Count the...

Hi Friends, Here is the data which I am trying to vlookup but did get a formula to that <colgroup><col span="2"><col><col><col span="12"><col><col span="3"></colgroup><tbody> ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG ColumnH ColumnI ColumnJ ColumnK ColumnL ColumnM ColumnN...

I wanted to make a study planner for myself. For that I have created three Excel Sheets namely Schedule, Tool and Status In "schedule" Sheet I have created a table as below <tbody> Slot 1 Slot 2 Slot 3 Date Status Topic Lookup Status Topic Lookup Status Topic Lookup...

I am creating a master sheet to analyze 6 other sheets in a workbook. All the sheets are formatted the same and have the same layout. I am trying to pull the entire row if one the the cells values is 0. I have used an index small feature before to do this with a single sheet but do not know...

Hello, Here is an example data table that would resemble mine. The columns with bold red text are the columns I need to develop a formula for: <tbody> A B C D E F G H I Task1 Task2 Task3 Task4 Task5 Row 1 1 1 1 2 2 3 4 4 1 2 3 4 Row 2 3 2 5 6 6 8 3 2 5 6 8 Row 3 2 2 2 1 1 5 8 2...

I have a large data set with a 'description' column that is not always uniform, for example it could read "bla bla bla depreciation" or "depreciation bla bla bla" and both should be tagged as 'Depreciation' in a separate tagging column. Is there a way/formula which I could create a mapping...