I originally posted this in the excel functions area, but now I am thinking
it may require some VBA to get it working. I have two lists, one with Stock
Symbol and Sector (Column U and V), the other with Stock Symbol (Col A) and
Price (Col B) and Position (Col C) and a few other metrics (Column A through
Column S). I'm trying to figure out how to lookup a Symbol in Column U, where
there could be TGH.N and find all matches in Column A, 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, as well as Position, and all elements in each row from Col B
to Col S.


I was thinking of something like this:
Range("A2").Select
..Value Like "*" Then

I think this is pretty complicated, at least for me.

Thanks!
Ryan---


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