Forum Discussion

Studio_2's avatar
Studio_2
Copper Contributor
Jul 19, 2019

Help on Excel Formula

Hi All 

 

I am looking to use two cells to determine if a third cell should be copied to another cell in sheet. 

The cells I will be using will be,

[Spend/Projection], [Funder], [Amount]

Basically I need a formula like if spend/projection = spend, then find Funder heading and copy and paste the amount into the proper heading and if Spend/Projection = projection then leave heading blank.

Can anyone please help me with this.

Resources