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.

A	B	C	D	E
Sold VIN	AGE		Purchased VIN	AGE
FMJ	32		RQR
LUT	67		FMJ	32
CCW	99		LUT	67

<tbody>
</tbody>

 

[admiral100]

Hi,

Try this:-

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