JeffGalbraith
New Member
- Joined
- Apr 9, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Is it possible to have a cell or a range of cells dynamically report the contents of a range of cells from another sheet based on a criteria? ie: SUMIF works great for finding cells in a table that are adjacent to cells matching a specified value, but that's only useful if they are numerical values and you want them added up. I'm workmen with text strings and want the listed out one by one...
I tried using TEXTJOIN such as:
=TEXTJOIN(CHAR(10),TRUE,SKILLS!C27:C35)
But in place of the bolded range C27:C34 shown above, what I really want is the formula to search through a large dataset and find the values adjacent to cells that match the contents of a specific cell. I tried writing the range in this TEXTJOIN formula as shown below by replacing the explicit cell range with a VLOOKUP function, but it just returns a #REF! output.
=TEXTJOIN(CHAR(10),TRUE,VLOOKUP(B5,SKILLS!B:B,SKILLS!C:C,TRUE))
I should point out that this option of using TEXTJOIN wouldn't' be my first choice because it will lump / concatenate them all together into a single cell, but if it's the only thing that works I'll settle for it.
Ideally the formula would be structured to that if it found 7 cells in the dataset that match the criteria, each of those 7 values would be entered into a column of 7 cells on the desired worksheet.
Are either of these options possible with excel? Or do I need to hire a programmer?
I tried using TEXTJOIN such as:
=TEXTJOIN(CHAR(10),TRUE,SKILLS!C27:C35)
But in place of the bolded range C27:C34 shown above, what I really want is the formula to search through a large dataset and find the values adjacent to cells that match the contents of a specific cell. I tried writing the range in this TEXTJOIN formula as shown below by replacing the explicit cell range with a VLOOKUP function, but it just returns a #REF! output.
=TEXTJOIN(CHAR(10),TRUE,VLOOKUP(B5,SKILLS!B:B,SKILLS!C:C,TRUE))
I should point out that this option of using TEXTJOIN wouldn't' be my first choice because it will lump / concatenate them all together into a single cell, but if it's the only thing that works I'll settle for it.
Ideally the formula would be structured to that if it found 7 cells in the dataset that match the criteria, each of those 7 values would be entered into a column of 7 cells on the desired worksheet.
Are either of these options possible with excel? Or do I need to hire a programmer?