index & match

Excel formula for multiple matches. Kindly help to find a formula in G3 and G4. I have data in column B and C, I wanted to match it with column E and F. However vlookup does not work as there are multiple matches. I wanted a result of True/False if B and C contains the values in E and F...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

Based on this table, I need help on creating a formula in K3 to count and in K4 to sum based on the following condition In K3 --> countif B1:G1 = K3, A3:A5 = K1, B3:G5 is number...

Hi everyone, I've looked and found several posts about using the greater than match type in index(match formula's but none have any with 2 match references and I'm stuck. I am building an AQL inspection table and want the sample size to be automatically indicated for our team however the value...

I am having some difficulty finding where to start with this , i have found a few codes in other forums but am not able to manipulate them to my needs , so here goes my best to explain this - So to start i have a spreadsheet with multiple sheets , this is a POB (personnel on board) , within...

Hello, as per the below, i have a sheet showing a page of info about different people. On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result. Is there a way to lookup (for example) "person 6" across multiple columns...

I am referencing an external workbook. Which has a table similar to this one below: (Assume the table starts at cell A1) First Name Last Name Concat Job Search Notes Peter Parker Peter Parker Y Wants a job as a photographer Bruce Wayne Bruce Wayne N Pepper Potts Pepper Potts Y...

Hi, I'm wondering what the best way is to return all columns (T and U) in the following setup: I have tried using BYROW/LAMBDA to no avail. Perhaps there is a better function than INDEX/MATCH for this?

I have a set of data (see picture attached), where different projects have several dates, even within same month (A3:B16). My goal is to build a ''calendar'' that will show Projects and their first date that will fit within the selected month. E.g. in the picture: I want to see the projects...

Hi, I am using Office 365. I've tried the Concatenation approach and using a Vlookup, but I think it isn't working because the cell contains both numbers and text. I spent a while trying to sort that out, but I think my files have formatting issues, even after using the TEXT function, so would...

I have multiple queries getting data from a combination of Database and Web. I am currently using a complex Index / Match combo (with multiple criteria) to combine data. The Index Match formula I have used is.. =INDEX(wellbore_formation_top[Lithostrat...

Sum INDEX-MATCH Across Multiple Columns with the Same Heading Hello - how - wondering if someone knows how to modify this formula to account for multiple rows could be a match? Same Data but now multiple rows and multiple columns match? instead of...

Hello, I'm trying to tweak the usual index match formula with multiple criteria to allow one criterion to be: if the cell contains. Normal: =INDEX(LOOKUPARRAY,MATCH(VALUE1&VALUE2,LOOKUPCOLUMN1&LOOKUPCOLUMN2,0),1) What I'm trying to do, but this doesn't work...

Hello! I have a problem I can't seem to solve. This is for a rental busniess that rents out products and gets them back at a certain date. I have four tables. Table A: A daterange based on ID, that's a key between table A and table B Table B: A table where one or more products can be reserved...

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

I'm trying to do a vlookup (or an index/match if those functions are better suited), to find values based on the matching date, as well as 2 headers on a single column, and then I need to sum the returned values. The challenge I'm running into, is that I need to pull the data that matches the...

Hi, I have a question and would kindly ask for your help to figure this out. Table 1, represents the date in which each product was acquired and the price paid for it. I want to perform a search in this table so it returns the price of a product to its closest registered date. TABLE 1...

Hi all, i've scoured the internet and have had no luck. I am hoping you guys can help. I am doing this in Google Sheet so hopefully some of you may know. I am trying to display the data/value from a cell that corresponds to a checked box from a different column and display into a new cell. I've...

Hi, We are trying to build a basic dashboard that is automated having to only paste in a raw data sheet that is cleaned and then uses the data from the 'clean data' sheet. At the minute we are trying to work out MODE of a text string within a range per week client activity is live. The...

Hi, I have created macro which suppose to do the index matching, works fine but need to change to work with the with wildcard in the name. Thank you Sub index_reclaims() ' ' index_reclaims Dim w As Workbook For Each w In Application.Workbooks If (w.Name) Like "*Summary*" Then Exit...