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

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

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

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ryguy7272" wrote in message
...
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''.

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

Thanks to everyone who looked at this. Solution is he
http://www.microsoft.com/office/comm...r=US&sloc=&p=1

The one with the green check!

Thanks again Jacob!
Ryan---

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


"Don Guillett" wrote:

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ryguy7272" wrote in message
...
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''.

.