A problem with an IF formula - matching values

Hello!

I've faced an issue concerning an IF formula.

I need the values of column A to match the values of column B.

See the file attached.

In D2 type =IF(ISERROR(VLOOKUP(B2,$A$2:$A$435,1,FALSE)),"NA",VLOOKUP(B2,$A$2:$A$435,1,FALSE)) and copy it down the sheet.

Thanks but it shows "NA" all the way down

I get some matches further down the page with Alan's formula. However, what exactly are you asking for with "I need the values of column A to match the values of column B."?
If you use Alan's formula, if the code in B appears anywhere in A, it will appear in D
If you reverse Alan's formula
=IF(ISERROR(VLOOKUP(A2,$B$2:$B$11143,1,FALSE)),"NA",VLOOKUP(A2,$B$2:$B$11143,1,FALSE))
if the code in A appears anywhere in B, it will appear in D.

The main idea is: codes in column D are taken from column A - and mached up with codes from column B

A B D

X205425 X304460 X304460
X219159 X304450 X304450
X201105 X304439 X304439
X220783 X304412 X304412
X004771 X304410 X304410
X204874 X304387 X304387
X229855 X304387 X304387
X004959 X304386 X304386
X000804 X304385 X304385
X005421 X304385 X304385
X221177 X304385 X304385
etc

I tested before I supplied you with an answer. I went down the file and there were valid items listed in column D. What do you want to appear in Column D if there is no match. With my formula, an NA appears if you have a value in Column B and it does not appear in Column A. If this is not what you require, then I urge you to reframe your question and be more specific.

Then Alan's formula is the correct one. The first value in B that is also in A is line 142

You can then select the 3 columns and Sort (Z to A) on "D"

Sorry, I'll try to be more precise. It's not mandatory for the codes to be in one line in columns A and B,

whereas codes in column B and D must be on one line.

The principle is: the code is taken from column A and it's brought to column D where it meets the same code from column B.

E.g. A198 and B4661, consequently column D must be equal with A198

(or e.g. A186 and B2345)