The value being look up are in a column B
Then start the crazy part.
For each match in column B,
(Value in column J + Value in column P) * Value in Column I
This needs to add multiple rows if the match occurs numerous times.
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.
What is Send to Mail Recipient?
This video walks the viewer through the process of creating Hyperlinks for the web and other documents.
Select the "Insert" tab:
Type "http://" followed by a web address to reference a website or navigate to a document to ref…