has this uploaded correctly?
the question is in cell L24 and asks: how, when i enter a "ticker" from column A into cell I23, do i return a "list" of all tickers (ie fields in column a) which contain the same value as the ticker in column d, into column L?
ideally in column L but it does not really matter as this is just an illustrative spreadsheet
This is not quite what i wanted. Assume that my question is in another tab (ie cells I and J 23 are in sheet2). My vlookup returns "soft luxury". I want to then see a list of ALL values in column A which have soft luxury as their value in column D. The location of this list should be next to the answer to the vlookup question, and populated downwards. If this is not clear, please call +44 7557 360922
let me try to explain what i am using this for. I enter a stock code - in this case RL US Equity. What i want to do is for a list of all stocks in the same sector to appear next to it. So cell K or L or whatever should be populated with every "soft luxury" stock - starting with 1913 HK (taken from cell A2 because in column D2 there is "soft luxury") and ending with LUX IM (taken from cell A23). please accept my apologues if i have not been clear
because i have a list of 5000 stocks which trade. i look them up using "tickers". when i enter a "ticker" the vlookup tells me which "sector" they belong to. The codeI am hoping for an answer to will then deliver me a list (of tickers) of all of the similar companies in the same sector
thank you. this is just what i wanted. however i cannot get it to work when i paste it into my original document. would you have 5 mins to remote onto my machine when i return from a meeting in one hour? I will happily increase the fee because you have been working on this for so long (poor communication on my part)...
i am back at my desk now