I have a sheet that in a cell I want to search a range (O19:W27) and if it finds an exact match to the data in (F7) EX:"SDM-0011" ---data will have numbers and letters and will change. If it finds that exact match in the specified range it grabs the number in the same column above it on row 16.
Sometimes the same match will be found in the specified range more than once so I would like the number grouped together separated by comma.
Ex: if found in 2 spots and the number in row 16 are 2 & 3 then it would return "2,3" in cell (E11)
I use this formula on other parts of the sheet
=IF(F7="","",SUMPRODUCT(($O$19:$W$27=F7)*IF(ISNUMBER($O$7:$W$7),$O$7:$W$7)))
an array that adds the numbers together that match what it was looking for but instead of adding the data together I want it to display it as it is.
Right now it returns "5"
what I want is "2,3"
I know its doing it because of the "sumproduct" but can I use something else to give me the result I want
Bookmarks