In more detail: I have one document (1) with a 2 columns (Names, and Prices)

In my other document (2) I also have 2 columns (Names and Prices)

In document 2, there are more names than there are in document 1 so I wrote this formula to check if the name in document 1 has an overlap with a name in document 2.

Please Login or Register  to view this content.
Next I wrote the following if statement to import the price over from document 1 into document 2 if there is an overlap. "If there is no overlap print no price, if there is print the price from the address I received from above in document 1". However, I am not sure how to convert that pseudocode into actual code for excel. If anyone can help me out with that I'd greatly appreciate it. Thank you

What I have so far: 
Please Login or Register  to view this content.
Please also let me know if I can provide more info.