table array

  1. H

    Vlookup using external workbook as Table Array

    Hello. I have got incentive reports and every month we get spread sheet of data. I need to Vlookup certain datas e.g checking if there is any new users in the report. All the master files have the same title of "3 digit number" INCENTIVE REPORT. I have come up with this formula the highlight in...
  2. F

    dynamic table

    hi, in sheet1 I have source table: <tbody> Car Year Color Type Audi 2000 Red Sport BMW 2001 Black Coupe Volvo 1998 Yellow Combi VW 1996 Black - Fiat 2003 Red Family </tbody> Then in sheet2 in A1 I will be selecting car name (Audi, BMW etc). Now if I choose "Audi" I want to in...
  3. R

    TABLE - Array formula slowing down save process

    Hi everyone I have had a table array formula set up for many years in my main spreadsheet. I also always have my xls set up with "automatic except tables", so the tables only calculate when I want them to, or when I save. A few weeks ago I added several (60-ish) columns to a different tab...
  4. D

    formula required

    Hi all I need a formula that can recognise the common demonators below and then add based on this common demonator. Please see the below - the bolded numbers are where i need the formala. Basically its to recognse where a and b are in the top table and then add the numbers in the second table...
  5. J

    VLOOKUP when Table Array Changes

    Hi, I'm new here, and I have a question regarding a problem I ran into today, at work. I am basically using the VLOOKUP function in a sheet (sheet1), to pull out data from another sheet(sheet2). But on a regular basis, the Table Array from sheet2 is changed, because the data from sheet2 is...
  6. T

    VBA Summarize data based on information in table

    Hi all= I wonder if anyone has a slick solution for this problem. I have information in a table that corresponds to data in an excel file. I need help with some code that will use the information listed in the table to summarize the data in the excel file and drop the output in a new sheet. I...
  7. J

    IF Formula, Excel 2010, Choosing in table only those items that are present on another table/list

    I have established two tables: the first being records over a long period of time(lets call it "AllTime"), including names; the second being only the names of current employees (lets call it "Current"). I am trying to establish an equation in a column of the "All-Time" table where if an employee...
  8. C

    When VLOOKUP returns #N/A when there IS AN EXACT MATCH

    When: -VLOOKUP fails to recognize your exact data match within the table array, and returns #N/A. I originally called this post VLOOKUP IS BLIND!!!! As I was writing the post asking for help I came up with the clever solution :rolleyes:! Here it is! Copy your data into Notepad and then...

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