I have to find all values related to specific data from one table. Case is that data by which I have to search can appears more than once, but values will be always unique, do not appear more than once. The issue is more complicated, but there is no need to explain, I just can’t deal with that part, cause I can’t use a macro and can’t use the filters. I has to be done that I write data in specific cell and under that cell, thanks to excel formula, I can see all related values line by line. Could you help me?
I’ve tried to use vlookup formula, I didn’t worked. I think I can deal with index + match formula, but I stopped in a moment when I have to find the related values pointing a position -1 to first retrieved value. It seems that my solution is very complicated and maybe it is simplier version.