Fill column by comparing numbers in different cells

[Jokerski]

I have a problem with my formula.

I have column A1 to A7000, B1 to B7000 ( they are from another worksheet copy pasted to the new one, column A have bar codes, column B articles )
The next columns in the new worksheet are C1 to C5000 ( the C column have bar codes that are contained in column A or might not be contained)
There are D E F G columns that are connected with C column, so i can play only with A and B.

What i need is the articles from column B to be sorted so that can match the bar codes in column C.
EXAMPLE
A B C
3830050585779 7615109000 5905784308036
5905784307336 0402291500 5905784308043
8716200454995 0402291900 5905784308050
8716200368209 0402291900 5905784307336
5905784308043 0402911000 5905784314297
5204239207734 0402911000 5905784303390
3245412580031 0403903900 5905784303383

Thank you very much

[Jokerski]

Pls Guru's help me....

[Jokerski]

Pls... I can help in my range of knowledge to someone.... This is to difficult for me...

[kvsrinivasamurthy]

Give Example how should be your result.

[Jokerski]

Thank you for your reply.

It should be like this
A B C
3830050585779 7615109000 5905784308036
5905784307336 0402291500 5905784308043 0402911000
8716200454995 0402291900 5905784308050
8716200368209 0402291900 5905784307336 0402291500
5905784308043 0402911000 5905784314297
5204239207734 0402911000 5905784303390
3245412580031 0403903900 5905784303383

As you can see in the Column D are the answers of the formula. Cell D1 should look into column A for the number in cell C1 and if the answer is for example A3200 it should copy the number of cell B3200 and paste it into D1.
From the example above. The cell number 0402911000 is in D2, how does it go there. The formula in D2 looked in column A for the number 5905784308043 in D2, and found that it is in the cell A5 and copied the cell B5 and paste it into cell D2.
That is what i need, sry for my bad explanation. I'm trying to explain it as best as i can. Ask me for something i can answer. I don't have that formula from the example, it is made manually.

[kvsrinivasamurthy]

In cell D2 use this formula and Dragdown.Columns A,B,C Contain your data.

Please Login or Register  to view this content.

[Jokerski]

I'm having some errors, do i miss something. Thank you very much for this
tar.jpgtar2.jpg
This is the real Document tar3.jpg

[kvsrinivasamurthy]

Pl see the attached file.

[Jokerski]

Thank You very much !!!