index & match

Hello. This is round 2. I posted the question yesterday, and got a terrific response, but i neglected to mention one thing - The current formula is incredible, but works on a row by row basis. Index/Match - Return value if partial text from cell contained in separate column however, I forgot...

All this works correct except for the Index match method say`s run time error 438? Anyone know why? Option Explicit Sub VLookup() Dim SrcReD As Workbook, Alton As Workbook, Cov As Workbook, Basildon As Workbook, wb As Workbook, BName As Workbook Dim ws As Worksheet, SrcRed_ws As...

Is there a way to perform a index match function if 2 conditions are met. I am able to get the correct results if I use the below function alone =INDEX(sheet2!C2:C2318, MATCH(1,(sheet2!A2:A2318=sheet1!X567)*(sheet2!B2:B2318="Replay"),0)) But I need to execute this function only if sheet1...

I need help in linking images when I enter SKU no in a quotation format. I have two sheets, one is a base file in which SKU no is in B2:B4000 and their corresponding images in E2:E4000 (images are inserted into the cell by copy-paste from PPT/PDF/websites- No URL available). Another sheet is the...

Hello! I am trying to find a formula where, using a static book size (say $1550000) and dollars over goal (say 250000) it will return the % at which commission is applied & can then calculate the annual bonus. For the example this would be 4% as the book size is between $1.5m and $2m, and the...

Hello There, Reference to the attached sheet, what is the best formula that I can use in Dashboard tab in Cell AL30 to check in Extract tab if there are figures for that specific month and to return it for specific segment, for instance in AP30 in Dashboard tab, it returns the Occupancy for...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...

first, I'm sorry for another index-match question, I have noticed a lot of these topic here. But I can't find one that helps me. Possible that I just suck a searching. But I've learned a lot from this site. Working on the Dutch version of 365 Question one: My excel file consists of a...

Hi all, I am hoping one of you great people can help with a simple problem (I think) that I can’t get my head around. I am trying to use a COUNTIFS statement alongside a HLOOKUP. In Sheet 1 in columns C to F, I want to count the ‘Modules’ (Test1 to Test8) in Sheet 2 that = 1. The First...

I have two tables. In the first table are the rates by resource (columnA) and the MonthYear (ColumnB-Y) In another table, table 2, where I have the resource (columnA) date MMDDYYY (columnB). I need for table 2 to look up and match both the resource and date from table 1 and return the rate...

Hey everyone! Maybe its a bit of a hard to understand question but I will try my best. I am creating a custom ribbon and in this ribbon I want a "Easy index-match" button. When the user presses this button 3 pomps in a row will pop up. The first prompt will ask the user to select the target...

Hi, I am looking to create a calendar on the first tab of a workbook I have. Currently the workbook has multiple sheets of data, each sheet containing data related to a different type of work that is being scheduled in for different people. In order to currently find out what type of work...

I want to return a list of headers in column R wherever there is a value match in column N. Column n contains extracted phone numbers, which I use as ID's Where TRUE exists in any row of a column AB to AK, that header (AB1 .. AK1)) is returned plus a line break, for each of columns AB:AK...

Having trouble creating a formula that will populate "pay date" based on first criteria "color" and date that falls within date range. Is there a simple way to do this? For exampling hoping to achieve that the formula will start by identifying "BLUE" in Color column, Then return value from Pay...

Hello, I need to find the row that matches the most number of parameters. I have two datasheets. One table "Table23" with a set of rules that can contain a specific value or a *. Table23: In the second table I need to get values and match them against this table to find the truest match and...

Hello, looking to have a recap table of attendance as follows: - From the dropdown list you choose between 3 options and i'd like to have a count of sick days, timeoff and Tardiness for each employee for March, April... What formula would fit in ? I tried with some Countifs mixed with...

Hi all I have these two formulas which work but I need to combine into one formula. I tried a few things but unsuccessful and given up. I could create helper columns but rather use single formula. =IF($A11="","",IFERROR(IF(INDEX(PDA!$B$2:$B$1048576,MATCH(TRUE,ISNUMBER(SEARCH("*"&"Code...

Hello, I'm currently working on a project with employee data and need to create a table that displays each employee's score for 5 different KPIs during each month of their employment. I have a huge table with all the relevant data and was trying to create a pivot table or write a formula that...

Hi all, I am trying to use a partial text search in one of the matches and it is not returning any results. I've used this method numerous times in the past but never with a partial search. Can someone please take a look at my example below and let me know if they can help? In my example, I...

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