index match

  1. K

    Lookup Approximate match against multiple criteria!

    Hello Everyone, I have a data table and i want to find approximate match against that table, CATEGORY DENIM DENIM NON_DENIM NON_DENIM RANGE NORMAL WASH HEAVY WASH WASH DYE 999 8.00% 12.00% 8.00% 12.00% 2,999 6.00% 8.00% 6.00% 8.00%...
  2. A

    Match Index? How to split a saving value across 12 months based on month of saving realisation and other controls

    HI, I am trying to create a savings log which would enable us to detail down the savings we generate as a business. Essentially the main issue I am facing is that I can dedicate fields to detail the saving total along with a date that can be used to identify a realisation month for the saving...
  3. L

    Find related items based on multiple criteria > index+match multiple criteria or somthing else?

    Hi all, This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match. Simplified example of the data: <tbody> Item Spec 1 Spec 2...
  4. M

    Index Match Match.... It just wont work :(

    I am an avid VLookup user and have recently learned of all the benefits of Index Match and Index Match Match.... I just cant seem to get it to work on my workbook! I would be extremely grateful if someone would be able to help me. On tab named 'Database' I have a table of data in cells A4:EV7...
  5. G

    Index Match with Right Function

    I have an index match that gives me results for prices with a string of text I want to remove. Example: USD 41.99 In a separate cell I have the RIGHT function to remove the "USD ", but I would like to have a single formula in one cell...
  6. M

    Ranking with Index Match Functions

    'm looking for some guidance on creating this lookup in excel. i have a table similar to below: <tbody> A B C D E F G H 1 STATE SalesPerson Count Percentage RANK MA TX 2 MA AA 68 99.4% 1 CC DD 3 MA BB 393 97.5% 2 AA CC 4 MA CC 566 100.0% 3 BB EE 5 TX BB 319 0.0% 4 - BB 6 TX...
  7. R

    Finding Last Test Date for a Student

    I have a large data table that was not very well put together. I need to find the last test date a student took a specific test in a range that contains also contains dates for the other tests they've taken. My table is as such: ID | LName | Test Date | Math Test | Score | Eng Test | Score |...
  8. K

    Help with matching by alpha and by number

    Hello, Excel friends. I am trying to wrap my head around how to match by alpha and by number. I have below an example of what I'm going for. Example: Meeting group discussions with one group leader for every room number. People assigned to room one with the last name between a-ch will have...
  9. P

    Formula Help: Counting Blanks

    Hi I am struggling with writing a formula to achieve the following: We want to count how many times there are two or more consecutive blanks. Below is a snapshot of what the data looks like. https://imgur.com/a/SP7Ojyz In addition, while we are here - We have the following formula...
  10. D

    Using Multiple Criteria in Index Match Array formula

    Hi, I was using an Index Match Array formula to get multiple results according to one criteria. In this formula, I am able to get the list of names for location "XX". That is A, D, E...
  11. D

    How can I determine multi-level value fees from a table of fees for a given value?

    HI Guys/Girls I need to change my formulas and/or lookup table structure to calculate a new fee structure bring implemented in July by eBay. I need to determine multi-level value fees from a table of fees for a given value. Reader background info If you look at the Research Tab This is used...
  12. V

    How can I calculate this Faster?

    =IFERROR(IF(P4=1,SUM(O5:INDEX($P5:$P$2100,MATCH(TRUE,($P5:$P$2100=1),0)),-1),"")/R2,IF(P4=1,SUM(O5:INDEX($P5:$P$2100,MATCH(TRUE,($P5:$P$2100=1),0)),-1),"")/R2) Would a UDF calculate this faster?
  13. B

    Excel stopped accepting array formula

    I'm not entirely sure how to explain this issue, so apologies if the title is confusing or misleading. I have a spreadsheet with a fairly large number of array formulas. Maybe there is a more efficient way of doing it but this is where I'm at for the moment. The formulas were working. However...
  14. I

    Totaling columns based on multiple criteria. SUMIF? SUMIFS? INDEX/MATCH?

    hi all, i am looking to analyze a large set of data and to do so have developed a sort of basic dashboard. in said dashboard, there is a dropdown (data validation list) with a month name that corresponds to the data set i am analyzing and in which the months are listed horizontally across the...
  15. 2

    Lookup a value based on common factors in the same row

    I apologise in advance. This issue can seem complicated. However, I'll try to simplify this as much as possible, without leaving out important criteria. I work in the quality engineering business, and I'll use the relevant terms here: Supplier number — This is a number that identifies a...
  16. W

    Need Named Range Formula to Auto Adjust for Every 5 Rows

    Hi everyone - I am trying to avoid creating hundreds of named range formulas. I have set up an image box to display one of three different images in A2 of Sheet1 if B2 of Sheet1 contains one of three specific values, no image shows if B2 contains the value "0". The formula I use for this named...
  17. S

    Index Match Across Multiple String Criteria

    I'm sure there is an easy solution, but my brain (nor google it seems) can find it... I'm trying to match two string criteria in an index match formula and I dont want to use an array. <tbody> A B C 1 Vial ID Batch 2 V001 Z001 1 3 V002 Z002 1 4 V003 Z001 2 5 V004 Z003 1 6 V005...
  18. P

    INDEX MATCH with a COUNTIF for duplicates & CONCAT Function?

    <tbody> R S T 51 HNL@internet.com HNL HNL@internet.com 52 SJC 53 OGG@internet.com OGG OGG@internet.com 54 HNL@internet.com HNL </tbody> I get the above results using the following formulas in U51:U56 And it removes the duplicate but how can I...
  19. A

    Help with thrid critera with index match and greater than

    <tbody> D E F G H New Lamp and/or Luminaire Initial Light Output of new End-User Equipment (lm) New Lamp Circuit Power _Watts Coef Factor Remarks 3 E1.1 A LED Lamp only_ELV 1600 2 0.49 ≤5 W=.0.49, ≤10W=0.41...
  20. D

    Index Match problem

    Using INDEX MATCH I can check if a key word is in a cell and return the name of the group it belongs to. Fine. But what if I want additionally check to see that it does not contain a word/phrase that would mean it is in another group, or there is a second keyword which must be there for a...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top