index / match

I have a macro that was running into issue mainly due to using the .select too much so I am trying to remove it from my code wherever possible, but I am unsure how to rewrite the following formula: Range("L9").Select ActiveCell.FormulaR1C1 = _ "=INDEX('Previous...

Here's probably an easy one for you experts. I need to count the non-blank cells in a row. The twist is I'd like the formula to also figure out which row to count from. In my sample workbook, I have the "Overview" worksheet, which contains the rows of the table that needs counting. I have a...

I am trying to easily reconcile two different accounting reports: one from our local system, and one from our accounts payable department. I've copied and pasted the data into a sheet as follows and am trying to determine where there are discrepancies between them: From our local system (lines...

So i am trying to create and evaluation sheet for my employees. The first screen shot is all the necessary data that i need to pull from. The second screen shot is where i want to put all my data to I can then use it for my evaluation sheet. I enter the employee name is the first column which...

I've been fighting with trying to get this to work and have been scouring the internet for answers. I am needing find the SUM of Column C values where Columns A & B match and that SUM would be in D1 as in the example below (not a formula in D1 Example). Currently I have the following formula...

I am trying to modify the below array to determine if a date and PO number have already been returned as a result for a date then skip to the next PO. see the attached screen capture which is returning the same PO number multiple times in the calendar. I'm using named ranges (CalList, PO_Number)...

Hi guys, I'm in a pickle for a few days now. My problem just wont go away and I've wasted few days on trying to solve it. I'm ready for some help since I hit dead end. Let me be as simple as I can. Sheet 1 <colgroup><col><col span="4"></colgroup><tbody> CUSTOMER RATE 1 RATE 2 RATE 3 RATE 4...

I need to convert many Bills of Material from an 'Indented Levels' list into a 'Parent-Component' list. That is, I want a formula on each row that reports the Parent part for the part on that current row. I have tried to use Index-Match, but can't get every row to return the correct answer...

I have a list of phones with names <tbody> 111-111-1111 John Doe 111-111-1111 Jane Doe 222-222-2222 Scott Johnson 333-333-3333 Dave Murphy 333-333-3333 Pat Keesel 333-333-3333 Josh Vanty </tbody> I have removed number duplicates and would like the following results...

I have a table that looks like the one below with the dates sorted in descending order. Person Date Number Jose 1/1/2014 98 Rosa 5/14/14 47 Jose 6/1/14 3 Rosa 2/1/15 456 Jose 12/5/15 3 Rosa 5/2/16 -10 I want to enter a name and date and have excel search...

Hi, this has been driving me crazy and i am unable to find a formula to drive me the result. Please refer to the below case. <tbody> A B C D e 234563; 234575; 564543 Apple Yes 234575 (Apple) 223344; 278923; 232324 mango No 232324 (Mango) 123456; 567890 banana Yes 123456 (Banana)...

Hello again! Once more I need Your Help. This time again situation is tricky one. I have Item list with Style #, description, sizes and price in one workbook (they are total over 500): Unknown <tbody> A B C D 1 Style Description Size Price 2 P1111 Ladies Polo 8|10|12|14|16|18|20|22|24...

I've been looking through the forum for an answer, and although I've seen some very similar posts, I can't get a definitive answer for my issue: Here is an example of what I am working with and what I'm trying for my INDEX MATCH...

Hey all, I am new to this forum and am only beginning to learn VBA. I am trying to create a VBA that will look to sheet "x" and return all of the rows in sheet "y" if column "s" in sheet "x" is greater than 5. I am getting an error with the first part of my code, which I titled "Sub Screener...

Hi, I have searched and found code but none seem to work... Let's assume the following from a dummy table: Sheet = 'Users' <tbody> A B C 1 Name Empl ID Manager 2 Mark 00001 Manager 1 3 Sue 00002 Manager 2 4 Joe 00003 Manager 3 5 Mary 00004 Manager 2 6 Jeffrey 00005 Manager 1 7...

Hi all, I have a payroll file made with several sheets. I store almost all data in the sheet I named Main DB. In this sheet mostly the working hours and some other attendance exceptions are calculated and converted to 0:00 time format. Then in other sheets dedicated to each month, the relevant...

Hi all! I have a macro that fills a sheet automatically using .Cells().Value=Application.Vlookup().... Basically all I want to do is change the Vlookup to Index(Match()). I know the first thing is to call the index function with Application.WorksheetFunction.Index() etc.. I have a workbook...

Hello, I am trying to figure out a way to return one value based on two criteria. One criteria is in a vertical array, whereas the other is in a horizontal array. See the tables below for more details. Table 1 <tbody> A1 text text text 10.01 text text FORMULA 10.02 </tbody> Table...

Hello, I am trying to index/match multiple criteria. The formula below meets most of my needs but I need the match type to be 1 not zero. =INDEX(E23:E5000,MATCH(A3&B3&F3&C3,A23:A5000&B23:B5000&F23:F5000&C23:C5000,0)) All the criteria will match in their respective columns exactly, except for...

Looking at this image: View image: ex 4 I want to be able to in cell C2 have a function that looks at Cell B2 and if it says "Yes" look at Cell B1 and it it reads "No" return value A1. For cell C3, what should happen is that it looks at B3 sees "Yes", then looks at cell B2 sees another "Yes"...