Extracting multiple lists by category
Hi. I have a master sheet where each row is allocated one of four categories. I would like to extract this data into another sheet, into different columns dependent on the category (i.e. four columns for name, one per category, four columns for date, one per category).
All the functions I have tried (vlookup, match/index etc.) only bring up the first result for each one. I know I can create reports to show the data, but this wouldn't work as I need the data to build a dashboard.
Can anyone help?
Help Article Resources
Check out the Formula Handbook template!