Data relation

[siddiquera]

Hello Everyone,

This one issue is simply too cumbersome for me to handle, any help will be appreciated!!

I want to move a specific number which represent one ticker one sheet to a different sheet which has the same ticker.

For Example this is the current file:

PERMNO NASDAQ Ticker
15318 19771209 ASBC
59408 19981001 BAC
71563 19990104 BBT
16548 19910424 BOH
76892 19910905 BOKF
85789 19970515 BXS
70519 19981204 C
25129 19721214 CBSH
27888 19970814 CFR
93150 20091210 CIT
25081 19910402 CMA
23916 19900517 CYN
86719 19990208 EWBC


I want to transfer this to a file that looks like this:
Ticker PERMNO
ASBC 15318
ASBC 15318
ASBC 15318
ASBC 15318
ASBC 15318
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BAC 59408
BBT 71563
BBT 71563
BBT 71563
BBT 71563
BBT 71563
BBT 71563
BBT 71563
BBT 71563

There are over 392 variables like this so I could write out a detailed IF function.
The ticker would indicate the change in the PERMNO. Where ever the ticker pops up so should the PERMNO. I just need the data to do a lookup and match the data.