Excel Formula HELP PLEASE

Copper 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

Hi @Studio_2  

I have attached a sample file. Please refer it. You may also share your actual file so that more suitable solutions can be found. Thanks,

Tauqeer

Please illustrate your given data and desired results through a sample file.

@tauqeeracma I have it sorted basically all I need now is this formula to return a blank cell if the other cells are blank the formula is; =IF(E10="EA/ENIC",IF(F10="Spent",D10,IF(F10="Projection",0)))

this does near enough everything I want it too except it returns false is cells E10 and f10 are empty