Assign new value over undefined number of horizontal cells

[silkroad69]

Hello,

i am an excel noob who can use some help from some experts.

I currently have table 1 and table 2, and need to create the table "table needed". Please see image:

EXCEL-TABLE.png

table 1 has all data of which number fits to which Letters.
table 2 has an undefined number of horizontal cells with te same numbers as table 1.

Now i need to create a new table as table 2, but with the letters behind the correct numbers.

Help is much appreciated!

[Glenn Kennedy]

Assuming that your data start in A1 (i.e. so that 1001 is in A2)...

=VLOOKUP(D2,$A$2:$B$6,2,FALSE)

copied down will do that...

[silkroad69]

Assuming that your data start in A1 (i.e. so that 1001 is in A2)...

=VLOOKUP(D2,$A$2:$B$6,2,FALSE)

copied down will do that...

thanks alot!!!
marked as solved