INDEX/MATCH to retrieve several cells
Hi
I am using the following formula =INDEX({Source Sheet Range 1}, MATCH([Dev Resource]1, {Source Sheet Range 3}, 1)) to retrieve data from SourceSheet to MJ2 sheet.
The formula retrieves only one record when I need to retrieve all records associated with MJ.
Anybody ran into this issue?
Thanks
Xav..
Answers
-
Do you want each project in it's own row?
-
Yes I do
-
You should be able to adapt THIS to fit your needs. You are definitely going to need to update the formula in String1 to reflect the proper cross sheet references.
EDIT: Included link to published sheet.
-
In your example would your List column match my Project Title column, your Comma column match my Dev sizing column?
-
The List column would match your [Project Title] column, but the Comma and String columns would need to be separate. They will not match any columns as they are in place specifically for parsing.
The way it basically works, is we use the JOIN/COLLECT in String1 to pull all of the values together into a delimited text string. The the Comma column and the rest of the String column is used to parse that data down the List column or in your case the [Project Title] column.
To pull additional data, you would need to use formulas with cross sheet references such as INDEX/MATCH or VLOOKUP, or you would use cell linking.
-
Thank you for your help on this Paul.
Xav..
-
Happy to help. 👍️
Please don't forget to mark the most appropriate response(s) as "helpful". This will let others searching for a similar solution know that one may be found here.
Help Article Resources
Categories
Check out the Formula Handbook template!