index and match

  1. I

    How to Search/Find within cell to vlookup/Match & Index

    I'm trying to figure out a formula to replace a simple Vlookup formula because my data has mixed references. Table I need to pull data into. <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Order Line Cust. ID Drop Ship Ship Via PO 1362746 1...
  2. J

    Problem with index match to external workbook

    I have a number of index match formulas that I use in order to produce MI, but I am struggling to pull through data from an external workbook which is stored on a network drive, this is the formula I am using: =IFERROR(INDEX('[Consumer Timesheets 2016.xlsm]April...
  3. R

    PowerPivot Index and Match Help!

    I have written my formula in excel and now I want to convert this to PowerPivot DAX language. Does anyone have any recommendations on how I would convert the following formula? I'm just trying to pull Actuals over (Formula column) where State,Month and equal and where the Version equals...
  4. T

    Two-Way Lookup, NOT Using Matrix

    Hello! I am trying to use a formula to first Search vertically within a column for "VALUE A", then search within the row of "VALUE A" for "VALUE B", then output "VALUE C" from row 1 of the column that "VALUE B" is located within. Here is a photo of what I would like: I have found something...
  5. T

    Formula to find NEXT Unique Value in Row

    Hello, Here is an example data table that would resemble mine. The columns with bold red text are the columns I need to develop a formula for: <tbody> A B C D E F G H I Task1 Task2 Task3 Task4 Task5 Row 1 1 1 1 2 2 3 4 4 1 2 3 4 Row 2 3 2 5 6 6 8 3 2 5 6 8 Row 3 2 2 2 1 1 5 8 2...
  6. M

    A puzzling issue in an Index and Match formula

    Hi forum, I've been working on a dashboard to plot Tour De France results, and in the main it's gone ok. I've been working on presenting team stage winners in graphical form displaying the team shirt using INDIRECT, and that's all gone swimmingly. Then I thought I'd add a simple text box...
  7. D

    VBA Index and Match Macro Button Help

    Situation: I have a master database with 5 sheets that needs to be updated from 5 different sources of informations. All the accounts have unique IDs and I am looking to populate the columns in the masterdatabase from the columns in the raw data files with the matching unique IDs. The raw data...
  8. B

    How do I count number of occurences in the last 4 months?

    I have hundreds of names in, say, column A and the date I saw that person in, say, column B. The data goes back several years. What I am after is a way to count the number of times I have seen each person over, say, the last 4 month period. I might need to extend this to six months. Can a...
  9. A

    Index and Match across two sheets

    This should be simple but I'm stuck for days and spent 8 hrs on this today alone. Q1 I would like to look up the number of games played on Sheet 2 in column A for the correct first and last name and place it in Sheet 1 column D. I tried =IF($A3=0,"",INDEX('Court...
  10. M

    Reverse VLOOKUP, HLOOKUP

    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"...
  11. E

    Index Match Array functions

    Tried several index, match funtions but no success. Need expert help. Thanks in advance. Here is the table source with data. Table 1. Source <tbody> 1 A B 2 Basket 1 Apple 3 Basket 1 Pear 4 Basket 2 Apple 5 Basket 2 Banana 6 Basket 2 Grape 7 Basket 3 Banana...
  12. V

    please help..INDEX and match query

    I am trying to use INDEX and MATCH to help me to lookup another file to update values. File to be updated - Luni_report_try1.xlsx Values in column A & B (Volume and storage system names) to be searched on the second file (the lookup file – luni_trials_ext1.xlsx) and return Parity Group value...
  13. A

    Sumif entire table with multiple row and column criteria

    Hi! I'm attempting to sum all values in a table that that 1. match a specific value in a header (column) and 2. match multiple values in the rows (there are about 20 values). Each of the values I want the data to match are referencing cells that contain the value. The below formula I pasted...
  14. R

    Vlookup but with a twisy required solution

    Data on sheet One that needs to be copied to sheet two without using copy paste. <tbody> Exp July15 Books 9000 Goods 2000 Taxi 8000 Milk 1000 </tbody> <tbody> Revenue July15 Books 2000 Goods 9000 Taxi 12000 Milk 500 </tbody> <tbody> Exp July15 Books...
  15. R

    Lookup table headers

    Hi I have the following data set. I want to be able to build a formula that allows me to put in Group in Column A and a Rank in the table data) and the formula will return the Region in Row A. Can someone please help? Group Group/Type Name North East North West Yorkshire and the Humber...
  16. C

    Why does my excel crash due to circular reference warning?

    Hi Mr Excel, I have created a model and there is a row that is impossible to delete. When I try to delete it, the following error message comes up and I have to re-start Excel. 'Circular reference warning One or more formulas contain a circular reference & may not calculate correctly...
  17. D

    Is this possible without super advanced skills?

    Hey there, I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the...
  18. C

    Index Match data to provide multiple results in columns works in some cells but not others

    Can anyone view the picture? Trying to use this function to pull corresponding data from and copy horizontally to adjacent columns...Seems simple....The problem is the formula appears to work when I paste it down and over in some cells but isnt retrieving data from the list in other cells...
  19. G

    Index/Match Formula question

    I'm using an index match formula where the index is a named table called "UnemploymentTable" on another worksheet within my Excel workbook (see screen shots below). The trouble I'm having is when I drag my formula to the right, the index/match formula is going to my table and looking up one...
  20. D

    INDEX and MATCH , "Excel ran out of resources while attempting to calculate one or more formulars.."

    Hi All, I am new to VBA and need some help with few formulas. The first question is the Index and Match formula, it does not work for me. I have 2 sets of data as follows: Table 1: Employee Name(A1), Client Name that EE works this month (B1), Total Days EE works (C1)/month <-- this is my data...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top