VLookup在Excel中匹配插入(VLookup match insert in Excel)

 我是这个网站的新手; 如果我犯了任何错误，请接受我的道歉。 
 
 我需要一些关于Excel中的搜索和替换方法的帮助。 
 
 我的目标是从列中选择一系列随机值（例如，列D），并查看唯一列中是否存在该值的相应匹配（例如，列A）。 如果此值在列A中，我想将该值插入与相应值列A相同的行中，但插入另一列（例如，列E）。 
 
 我已经厌倦了各种不同的功能，如IF ， VLOOKUP和MATCH但到目前为止还没有运气。 
 
 有人可以告诉我如何做到这一点，或者甚至可以做到这一点？ 
 
 谢谢！ 

I am new to this website; if I make any mistakes, please accept my apologies.
 
I am in need of some help regarding a search and replace method in Excel.
 
My goal is to select a range of random values from a column (e.g. column D) and see if there is a corresponding match for that value in the unique column (e.g. column A). If this value is in column A, I would like to insert that value in the same row as the corresponding value column A but into another column (e.g. column E).
 
I have tired various different functions such as IF, VLOOKUP, and MATCH but have had no luck so far.
 
Can someone please show me how can this be done or if its even possible to do?
 
Thank you!

原文：https://stackoverflow.com/questions/18365821