Matching cells that have unrelated information
 

Hello all,

I would greatly appreciate if someone could please asisst me with my issue.
I'm trying to figure out a way to pair up information in two cells with
different values. Please see example....

Col1(Ticker Client) Col2(Share Position) Col3(Ticker Company)
Col4(Par)
TKxxx 1,200.000 ^Tkuxx
1,200.000


What I'm trying to do is find a function, formula or macro that will allow
me to take the "client ticker" and pair it with the "companies ticker" so I
can make sure I don't have share variances to the client. The clients ticker
is always different from the companies ticker and I have thousands of
positions to reconcile. I tried sorting Col1 and then sorting Col3 but I
still have to many securities(tickers) that are not matched. Does anyone know
a functions that can match the companies info to the clients info other than
sorting? Please advise. Your help is greatly appreciated. Thank you

Troy,

I think that you are probably confusing people by the way you have phrased
your question.

Col1 (Client Ticker) Col2 (Share Postiion) Col 3(Company ticker)
TKXXX $120,000 ^TKXXX

If you want to match items up then you need at least something that is
COMMON between the CLIENT TICKER and the COMPANY TICKER (but you have said
the these are different...just your wording)

So what is the common bit of information that will allow a join of these two
fields?

If there isn't one then you have no chance of joining them to begin with.

James

"Troy S." wrote:

Hello all,

I would greatly appreciate if someone could please asisst me with my issue.
I'm trying to figure out a way to pair up information in two cells with
different values. Please see example....

Col1(Ticker Client) Col2(Share Position) Col3(Ticker Company)
Col4(Par)
TKxxx 1,200.000 ^Tkuxx
1,200.000


What I'm trying to do is find a function, formula or macro that will allow
me to take the "client ticker" and pair it with the "companies ticker" so I
can make sure I don't have share variances to the client. The clients ticker
is always different from the companies ticker and I have thousands of
positions to reconcile. I tried sorting Col1 and then sorting Col3 but I
still have to many securities(tickers) that are not matched. Does anyone know
a functions that can match the companies info to the clients info other than
sorting? Please advise. Your help is greatly appreciated. Thank you