Formula for referencing two columns in another sheet.

Answered - Pending Review


I would like to add a formula for the partners' cell(image #1)

to reference the two columns in another sheet (image #2).

The current formula you see in the first image only references the Partners(existing) column.

Any help is deeply appreciated!


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You would want to create a new column in the source sheet that combines the two columns into one and then reference that.

Sign In or Register to comment.