Identical-function with a specific cellanswer

[LunaMortus]

Hello,

A B C D
1 sup 2 =IF(OR(IDENTICAL(C1;$A$1:$A$4)); ? )
2 rababer 4 =IF(OR(IDENTICAL(C2;$A$1:$A$4)); ? )
3 blubbel 3 =IF(OR(IDENTICAL(C3;$A$1:$A$4)); ? )
4 blub 3 =IF(OR(IDENTICAL(C4;$A$1:$A$4)); ? )

So if the value of the cell C(1....4) is in column A, if true, the answer i need is the respective cell in B.
I tried something with identical functions but have no clue who to get the result beeing the cell in B..

e.g.: C1 = A2 the answer should be B2 in D4.

Hope u guys can help!

[dosydos]

i didnt quite follow all of that but with using your e.g.
try this in D4

=if(C1=A2,B2,"")

[José Augusto]

I don't know if is this what you want
try

=VLOOKUP(L5,$A$1:$B$2245,2,FALSE)

Note: FALSE means exact match, TRUE means IDENTICAL match.

[LunaMortus]

Ok yeah i obv. didnt express myself very clearly, sry. :D

We got an article list here: A is the article number, C is the article description.
Say the L column is an order (list of article numbers) that i wanna assign the respective description to.

So i need to search in A the article number from L und the answer is the article description C.

[José Augusto]

Hi
If I understand try this

=VLOOKUP(L5,$A$1:$C$2245,3,FALSE)
(if L5 is in A1:A2245 then get the corresponding value in the same line but column C. Is that?)

[LunaMortus]

Yes thats it! I can only test it tommorow but ill let you know if it worked, thx for the help :D