Searching for a Value using a Match function within and IF statement

[emcgaffin]

Happy Friday All!

Below is a simple table of data that I need help with. In my real sheet Column A has over 7,000 Items. Column D (Col C is blank) has about 400. I am trying to figure out a formula that will Search column A for a match in Column D, then return the value of Column B in Column E. The red numbers indicate the end result that I am looking for. I have tried using the following formula but something is wrong: =if(match(D3:D5,A3:A5,0)B3:5,""). Am I close or am I really far off?

Thanks for the help.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]Sold VIN[/TD]
[TD="align: center"]AGE[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Purchased VIN[/TD]
[TD="align: center"]AGE[/TD]
[/TR]
[TR]
[TD="align: center"]FMJ
[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"][/TD]
[TD="align: center"]RQR[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]LUT[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FMJ[/TD]
[TD="align: center"]32[/TD]
[/TR]
[TR]
[TD="align: center"]CCW[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"][/TD]
[TD="align: center"]LUT[/TD]
[TD="align: center"]67[/TD]
[/TR]
</tbody>[/TABLE]

 

[admiral100]

Hi,

Try this:-

=IFERROR(INDEX($B$2:$B$4,MATCH(D2,$A$2:$A$4,0)),"")