Associating one column with another in Excel

[_MB_]

Hi there,

I have a column of data that has 1970 cells with mixed letter an
number codes. The values in these cells come from another column with
list of 1056 possible values.

Is there a way to link my original column with a numerical value from
to 1056 such that for example any time value A appears, "1" will appea
in a cell next to it (B with 2, C with 3 etc)

 

[firefytr]

not sure if i understand you. you could look at the ROW() function. o
if you wanted to set up a list, check out the VLOOKUP function. thi
may help

 

[_MB_]

tried VLOOKUP, doesn't do what I want it to, or perhaps I put in wron
info.

I'll try explaining again:

I have one 1970 cell column full of entries that take the form "FS1234
they represent movements of stock and the different codes represen
different locations.

I have another column with all the possible FS-numbers and anothe
column next to it numbering 1 to 1056 (the number of possibl
locations).

I want to take my 1970 cell column and in the adjacent column hav
numbers relating to the numbers 1 to 1056. The aim is to have a list i
"FS<number>" form and also in simple numeric form.

what I want then is something like this:

Column1 Column2
FS0001 1
FS0002 2
FS0028 12
FS0001 1
FS0010 8
FS0028 12

So every time a specific value appears, it correspond to its place i
the list, so FS0001 is the first code in the list, and FS0028 is th
12th

 

[Frank Kabel]

Hi
try using VLOOKUP for this

 

[Frank Kabel]

Hi
VLOOKUP should do. e.g.
=VLOOKUP(A1,range_with1056_value,2,0)

 

[_MB_]

Bless you

 

[tsides]

VLOOKUP should work. If it doesn't, please post the first few rows of
the 2 columns with your 1056 numbers and the text of your VLOOKUP
formula. By the way, VLOOKUP will work best if that list is sorted,
and you should use FALSE as the 4th parameter so that you're looking
for an exact match.