named range link

[na]

Normally I know how to paste a link to a spredsheet into a cell in another
spreadsheet - however I want to not only paste a link but I need to have the
formula pick - not from an entire row but from a named range - was hoping to
use this formula but just don't know to change it

The goal is to copy an entire row from one spreadsheet to another based on
data in column A so I would take the formula and drag it empty cells in the
new spreadsheet to pick up the data from the other

OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1!$A:$A)-1,COLUMN()-1)

 

[Spiky]

Normally I know how to paste a link to a spredsheet into a cell in another
spreadsheet - however I want to not only paste a link but I need to have the
formula pick - not from an entire row but from a named range - was hoping to
use this formula but just don't know to change it

The goal is to copy an entire row from one spreadsheet to another based on
data in column A so I would take the formula and drag it empty cells in the
new spreadsheet to pick up the data from the other

OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1!$A:$A)-1,COLUMN()-1)

I'm not positive I understand exactly what you want. But if your
lookup range is Named "Data", just change each instance of the range
to "Data" in your formula. Like this:
OFFSET(Sheet1!$A$1,MATCH(MAX(Data),Data)-1,COLUMN()-1)

Note there are no quotes "" in the actual formula when using a Named
Range.