Index-Match and Like...maybe...

[ryguy7272]

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---

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[ryguy7272]

Thanks to everyone who looked at this. Solution is here:
http://www.microsoft.com/office/com...997-20fd0e7f34e4&cat=&lang=en&cr=US&sloc=&p=1

The one with the green check!

Thanks again Jacob!
Ryan---