I have two Spreadsheets.
The first is the “Active Sheet” and has a list of contacts including name address and domain.
The second has the Domain in Column A and a formula in Column B.
I want the active sheet to search sheet 2, Column A for the Domain. If there is a match then copy the formula in Column B
Ex
Active Sheet
Dave Thomas; 123 address; abc.com
Susan Marks; 234 Address; def.com
Sheet 2
xyz.com; Formula
abc.com; Formula
dse.com; Formula
The result in the active sheet would be:
Dave Thomas; 123 address; abc.com; Formula
Thoughts?
