indexmatch

I am trying to use INDEX MATCH with three MATCHES and it does not seem to be working. It returns the #REF error. I have a table of data with titled rows and columns with 2 titles. The first match I do is for the row, then I do 2 separate ones for the columns. Where the rows and columns match...

I'm not an Excel expert and my HelpDesk hasn't been able to figure it out either so I searched for experts, and this forum came up! Here is my issue: I'm trying to solve for the cell "????" below. The 2 cells above it are entered so I'm trying to find the July 2018 row that has the date...

Hi Everyone, I have an excel table from where I would have to fetch value from master data. The report table looks like this. <tbody> Name Date1 Date2 Date3 Anir Rex Potter Shiva Rex Tango </tbody> I would have to fetch values from the a master table to...

Hello, I have a multiple index(match that works but I would like to add an IF(ERROR on the first condition so that I can eliminate the #NAs . INDEX('HOA-HOS'!$E$8:$E$12508,MATCH('3.Claim Line Detail O vs F'!$S4,'HOA-HOS'!$B$8:$B$12508,0))*INDEX('FS INFLATORS'!$D$2:$D$3,MATCH('3.Claim Line...

I have the following formula in several cells in column C from row 8 to row 61: =IFERROR(INDEX(Comments!$K$2:$K$76,MATCH(C22,Comments!$B$2:$B$76,0)),"COMMENT REQUIRED") Since it is an index match, only values are copied. I would like to implement VBA code that will preserve this index match...

Hi, I’m in the process of developing a reporting template and have become stuck. I’m working with a fixed report format and so have to produce a summary from separate tabs. I need to calculate the total spend for a specific quarter or year, depending on the value chooses from a drop down...

I have tried variations of index matches with if statements and SUMPRODUCT with multiple arrays all ending in errors. Can someone please help? I need to SUM the Value Column in the Source Table by matching the COMPANY NAME, PURCH TYPE, AND CATEGORY. In the example below the correct results...

Hi Everyone, Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance! Below are my sample data and desired result <tbody> Employee ID Sales Person Sales <tbody> S00001 S00002 S00003 S00004 S00005 S00006 S00007 S00008 S00009 S00010...

Hi all, I m trying a index(match..) formula with a dynamic range such as : =INDEX($X$13:$X$88,MATCH(F6,F13:F88,0)) F13 in F13:F88 definition needs to change depending on like F13+n rows For F13+n rows (assuming F13=Address(13,6) ) I used Address(13+G5,6) where G5 is autocalculated. But...

Hi I'm producing a user form for the purposes of data entry, I have two queries which I'm hoping the experts here can guide me with. The first one I'm hoping is a simple tweak in the code, but i have no experience of using formula in vba and not sure how to start it. Pretty sure its a IF...

Hi guys! Would appreciate a help on this one. I have the fundraising amount in one column and name in another one <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 100px"><col width="129"></colgroup><tbody>...

I am adding values together from 2 different sheets based on 1. date (in its own column) AND 2. if the description contains "AP" or "CD" (In another column) to populate on a summary tab. I have tried the following formulas: For my values containing AP or CD 1. =SUMPRODUCT(('GL...

Hi all, I am working through a spreadsheet converting multiple VLOOKUP statements to IndexMatch equivalients but have found one I can not work out. This VLOOKUP statement has a nested VLOOKUP statement that returns the value which needs to be looked up...

<tbody> MATERIAL TEMPERATURE ALLOWABLE STEEL 300 423 STEEL 350 427 STEEL 400 428 STEEL 450 425 STEEL 500 419 STEEL 550 410 STEEL 600 401 </tbody> Hi all, I have a table like this where I store my values. Also I have two textboxes inside a user form. One is for inputting the...

Good Morning everyone! Thanks for taking the time to try and help. I very much appreciate it. This has been a rather constant headache for a few weeks. I am attempting to create a training tracker in which reports can be ran based on multiple criteria. Currently, it is setup with VLOOKUP...

Hi there, I have the following indexmatch formula, but I want it to include an INDIRECT (if poss) =INDEX('Standard'!A2:M16,MATCH(C5,'Standard'!A2:A16,FALSE),M10) What I need to do is for the sheet called standard,to reference the contents of c9 to establish which sheet to look up on please...

Hey all! I'm trying to search sentences with construction activities for a specific part of that sentence, and give the corresponding output. Here is an example from the file I am working on: Column A: <colgroup><col width="416" style="width:312pt"> </colgroup><tbody> LEVEL 04 - INSTALL...

Good afternoon, I have searched the forums and was unable to find what I was looking for. Perhaps I wasn't using the proper search verbiage, if this has already been posted, I apologize. I have written 2 Index|Match formulas which are for separate employee locations. The reason there are two...

let me try and explain: List A has a list of names List B has a list of the same names but formatted slightly differently (some names include a middle initial, others include "PHD" after the name, etc.) How can I match List B to List A to make sure any of the same names, albeit formatted...

Hello, I have been trying to pull some data via Index(match. The match function is not working and I'm not sure why. I can see there should be a match and cannot figure out why. I've fiddled with the cells format each individually, then by Text to Columns.. No luck. I asked excel if the two...