ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to use master lists in Excell ? (https://www.excelbanter.com/excel-discussion-misc-queries/100872-possible-use-master-lists-excell.html)

Jens Outzen

Is it possible to use master lists in Excell ?
 
I want to be able to use masterlists and then copy from them to other
spreadsheets. Currently I have just linked them and that obviously doesn't
work. What would be the best way of creating a continuos link between a
masterlist and another spreadsheet - the problem is that the datarange may
change, not by much but still by say 5%.
Would vlookup be the best option ?

Max

Is it possible to use master lists in Excell ?
 
"Jens Outzen" wrote:
I want to be able to use masterlists and then copy from them to other
spreadsheets. Currently I have just linked them and that obviously doesn't
work. What would be the best way of creating a continuos link between a
masterlist and another spreadsheet - the problem is that the datarange may
change, not by much but still by say 5%.
Would vlookup be the best option ?


Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

INDEX/MATCH would usually be a more versatile option compared with VLOOKUP
which requires that the lookup column be the leftmost col, albeit this may
not be a problem if the key col in the mastersheet is always the first col
(say). We can also directly index the col to be returned using INDEX/MATCH
[eg INDEX(H:H, ...)] whilst with VLOOKUP, we need to figure out ("count") the
relevant col_index_num. But VLOOKUP is simpler to understand, and usually
shorter in construct. It's good to know and try out both options.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com