I have two lists, one with Stock Symbol and Sector (Column A and B), the
other with Stock Symbol and Price (Column D & E). I'm trying to figure out
how to lookup a Symbol in Column A, where there could be TGH.N and find all
matches in Column D, where the Symbols could be TGH.N, as well as TGH.400,
TGH.500, and TGH.600. The logic is, the first part of the symbol, up to the
period, will be the same. For instance, EL.400 and EL.500 are in the same
sector and EL.N, EL.400, and EL.500 are all in the same sector. I want to
lookup EL.N, EL.400, and EL.500 and find stock prices for each in Column E.

Thanks!
Ryan---



Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.