Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I would like to create a spreadsheet that contains name, phone number, address, email address of many individuals and I will define the data as a range name "Index". Then I would like to create a multitude of spreadsheets that contains some of the names and pull the phone numbers, email address etc from the spreadsheet that contains the various data. The reason for doing this is that I would have one place to store emails, phone numbers, names so I would not have to make changes to the multitude of files if the email address changes.



share|improve this question
Perhaps you can edit you question a bit, to make it more attractive to read (add paragraph). Can you share an example with us? –  Jacob Jan Tuinstra Jan 9 '13 at 21:29

1 Answer 1

Taking index as a keyword rather than range name and guessing that you would like details one person at a time rather than the complete set each time I suggest:

With a sheet (I've named 37372) laid out like so as your reference sheet:-

WA37372 example

then with this formula in another sheet in ColumnB and say Row3 and copied across to ColumnE:-


should provide the relevant details for say Jane when 2 is entered in A3.

If the formula is not in ColumnB I suggest the same process but then change column() to 2, 3, 4 and 5 as the formula is in columns further to the right.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.