=indirect

  1. 2

    =INDIRECT to return intersection of ActiveCell row and specific Column

    On Worksheet_SelectionChange in L1 I have VBA populate ActiveCell.Address Range("L1").Value = ActiveCell.Address Trying to figure out a formula, by using value in L1, to return intersection of ActiveCell Row and specific Column. I believe =INDIRECT formula might be a way to get it done...
  2. H

    Indirect function

    I have a workbook with over 20 worksheets, plus a summary sheet. The summary sheet needs to grab results from each of the worksheets and the results are in the exact same cell on each worksheet. I am using the INDIRECT function to do this. The INDIRECT function works for the first cell, but...
  3. A

    Alternative to "=indirect" to correct ext data table column change behaviour

    Hi, For reasons better known to Microsoft, references to a specific table column name change when my table order changes because of a change in the underlying external data fields. This doesn't happen in SQL, and I don't like it! I am loathed to embed a sequence of =indirect statements into...
  4. R

    Conditional formatting entire row based on a "between" date condition.

    I am trying to build a roster to track when Soldiers are about to get out of the Army. There are three windows; 30 days until ETS, 60 days until ETS, and 90 days. In column D I have the date that they will get out of the Army and I wish to format the entire row a specific color based on the...

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