named range link
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) |
named range link
On Sep 17, 8:48 am, na wrote:
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. |
All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com