external references

  1. P

    Check External Cell References in Row for exact match excluding blanks/zeros

    Hi all, I'm just writing as i'm struggling to work out how to check a row that cells match exactly whilst excluding any blanks. The thing that complicates this is all values are pulled in as external references from various other worksheets (L-Q in below example). I have done quite a bit...
  2. W

    VLookup works even after external reference file deleted

    Excel 2010 being used. I have VLookup references to another Excel file. After deleting the other file, the references still compute. If I change the array positional reference, it supplies the new value, even though the reference file has been permanently deleted. Does the file maintain a...
  3. H

    Accessing or importing dynamic data from external Excel file or sheet

    Hi there, I've been scanning the web for a way to access information from an external Excel document and use it in another workbook for analysis, but haven't found a way to do what I want. Basically, I want to pull in specific columns from an external sheet, which have a variable number of...
  4. S

    Retain References between 2 files (with change in sheet name or file name or location change)

    Hello, I have two files named A & B. File A has sheet tab 1 which has information from A1 to C3 which keeps on changing. In file B, I have references to file A. File A name, Sheet name in file A or location of file A can change. In file B, i want to create a reference to file A using some...

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