Help on Excel Formula

New Contributor

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.

3 Replies
Have you posted this in the excel forum too??

Adam

@adam deltinger Thats what I thought I did lol

Nope :) you’re in the first 365 forum! Go back to the community and choose the excel forum! there’s some pretty hefty excel guys there