I have a large master list database of names, address, etc...with different categories. Would like to use formulas if possible that will extract the information (names, address, etc) from a master list according to the different categories... into another sheet labeled according to the categories. I want it to also update each category sheet when I update the master list. Hope I explained myself OK.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
extracting information based on categories in a master list database
- Thread starter duwj
- Start date
Robert Mika
MrExcel MVP
- Joined
- Jun 29, 2009
- Messages
- 7,256
Hi duwj,
There are many ways to achive that.
To example:
VLOOKUP, INDEX/MATCH
Could post some data or explain in more details what woudl you like to do?
There are many ways to achive that.
To example:
VLOOKUP, INDEX/MATCH
Could post some data or explain in more details what woudl you like to do?
Upvote
0
Similar threads
- Question
