A compare formula

Hello, I have an excel file like below.

SV_plates	Row	Col	IDs	sample
SVI_01	A	1	1045	010-006P
SVI_01	B	1	1270	032-006
SVI_01	C	1	1274	034-014P
SVI_01	D	1	1276	035-016B
SVI_01	E	1	1277	038-022
SVI_01	F	1	1278	045-012
SVI_01	G	1	1282	047-011P

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,

SVII_31	G	4	3291	1234
SVI_03	F	10	3965	3291	SVII_31

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.

=IF(ISERROR(MATCH(E2,$D$1:$D$800,0)),"",INDEX($A$1:$A$800,MATCH(E2,$D$1:$D$800,0)))

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.