Jul 19 2019 07:24 AM
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.
Jul 19 2019 09:46 AM
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
Jul 20 2019 08:33 AM
Jul 22 2019 02:04 AM
@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