A compare formula

Hello, I have an excel file like below.

Please Login or Register  to view this content.

I want to add one column which is the value in the first column respectively. The condition is the cell value in 5th column matchs the value in the 4th column.
For example,

Please Login or Register  to view this content.

3291 matchs , then return "SVII_31" . In the above example, Cell E2 value is "3291", then we search D1:D65536, found D1="3291", then we add A1="SVII_31" to the new column. If not found, then noing added or add "NA" something.

Thanks for help.

Hi

With the data you have provide, there are no matches.

However, I think you may be looking for something like
=IF(COUNTIF($D$2:$D$383,E34),A34,"")

Put this in F2 and pull down.

Please Login or Register  to view this content.

Hey Roger - I got a single match on row 2.

Hi Marvin

You're quite right. A touch of brain fade on my part - should be gone to bed!!!
I read the question wrongly, AND posted a stupid solution.