Simonpyman
New Member
- Joined
- Jun 4, 2020
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hello,
I have explored different functions (VLOOKUP,INDEX,MATCH) but i cannot figure how to retrieve multiple values for the same cell name. In this case most of the cell names have duplicates with the exception of the cell 17 field. Cell 17 has 4 cells with corresponding values (57,58,58 and 55) but i cannot figure out how to display them in order that they appear in the light blue cells below (cell input data). I can only get the value 57 to appear using the formula that i created from an array of all the cell labels and associated values.
Example of the formula i have used so far:
=INDEX($F$106:$F$201,MATCH("NC",$F$106:$F$201,0)+1,1
Thanks in advance!
I have explored different functions (VLOOKUP,INDEX,MATCH) but i cannot figure how to retrieve multiple values for the same cell name. In this case most of the cell names have duplicates with the exception of the cell 17 field. Cell 17 has 4 cells with corresponding values (57,58,58 and 55) but i cannot figure out how to display them in order that they appear in the light blue cells below (cell input data). I can only get the value 57 to appear using the formula that i created from an array of all the cell labels and associated values.
Example of the formula i have used so far:
=INDEX($F$106:$F$201,MATCH("NC",$F$106:$F$201,0)+1,1
Thanks in advance!