Cell reference to a different Worksheet using row and column names

Question

Hi,

I would like to reference a specific cell in file A into file B using the row and column names.

Is this possible and how should I do it?

thanks in advance for your help

Damien

Answer 1

Thanks but I meant referencing the cell that is at the intersection of a named row and a named column.

A bit like the INDEX function but using names...

The problem with direct referencing to a cell's coordinates from a different worksheet is that it's not dynamic. If insert rows or columns the reference is lost and pointing to a different cell.

Any idea on how I could work around this?

Answer 2

Hi Miocaro, as long as you know the location of the other workbook that should be no problem . . .

Here is an example:

=C:\FolderName[WorkbookName.xlsx]SheetName!A1