index & match

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

Hello all, I am trying to lookup product names in a sheet I have and return the names in another sheet. So names in sheet 1 appear in column J rows 3 - 2000 and names in sheet 2 appear in columns CF rows 3-1000 And I want to show the names from Sheet 1 only if they appear in sheet 2 in...

Greetings - I have tried varations of INDEX and MATCH and various LOOKUPS, but I do not seem to be able to find the correct syntax to solve my problem. Any help would be greatly appreciated, thank you! I have 10 columns. In row CL1, if there is any data, the data starts in CL1 and cells to...

Seven groups of numbers are being compared. Based on the total points, I would like to determine the three most optimal group configurations (optimal meaning the highest and most equal values). These three groups will have the highest point value, but with the restriction that there are only 12...

Happy thanksgiving and Columbus day! Not sure if I'm thinking about this in the right way or if this is even efficient. I'm facing a couple of problems and can't construct the right formula. I feel it has to do with index, match, offset? I'm thinking about this problem in this way as I know...

The names of the products on the picture is NOT our products. I've made a look alike theme, with made up names, picturing the question I'd like help with. I need to purchase tons of flavours/month in order to keep production afloat, amongst many other products. The flavours are a big aspect to...