two tables

Hello, I have quite a challenge here .. I am trying to lookup multiple values from 2 different tables from different sheets in a single workbook (different from the one I am applying VBA to) I wrote this code from scratch but the from so I apologize in advance for the obvious errors or...

I have >100 files, all with the same make-up. I use Sample File to get a 'specific part of the table'. I also need '1 value' of this table from a specific cell, BUT this value is filtered out in the steps to get the 'specific part of the table'. I could Add (the '1 value') as New Query before I...

Hi Everyone, Looking for a sumifs formula which would return the state-wise sales value. I have two different tables. one is Date wise, city wise Sales data and another is state name master table. <tbody> Date City Sales Amount 01-02-2017 Mumbai 84,885.00 01-02-2017 Pune...

I am trying to write a macro to compare two different conditions between two tables and write a cell value if those conditions are true. Need to compare a column in Table A with a row in Table B if true, then need to compare another column in Table A with a column in Table B, if both conditions...

I've got two tables on two different sheets...while I could write vba code to loop through everything and calculate them, I feel like there's a way to do it with SUMIF or other formulas. I'm trying to find the value of an "original to new" change over time. If aa goes to ab in January, March...