ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to pull names and fields (https://www.excelbanter.com/excel-discussion-misc-queries/13078-how-pull-names-fields.html)

Brian S.

How to pull names and fields
 
Hello can anyone tell how I can get Excel to pull data from different
worksheets if the common thing between them is a person name.

Dave Peterson

I'd guess you'd want to use =vlookup() or =index(match())

And Debra Dalgleish has some nice instructions (for both) at:

http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Brian S. wrote:

Hello can anyone tell how I can get Excel to pull data from different
worksheets if the common thing between them is a person name.


--

Dave Peterson


All times are GMT +1. The time now is 04:20 AM.

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