Help on Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-764751%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20on%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764751%22%20slang%3D%22en-US%22%3EHave%20you%20posted%20this%20in%20the%20excel%20forum%20too%3F%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764765%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20on%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3BThats%20what%20I%20thought%20I%20did%20lol%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764768%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20on%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764768%22%20slang%3D%22en-US%22%3ENope%20%3A)%3C%2Fimg%3E%20you%E2%80%99re%20in%20the%20first%20365%20forum!%20Go%20back%20to%20the%20community%20and%20choose%20the%20excel%20forum!%20there%E2%80%99s%20some%20pretty%20hefty%20excel%20guys%20there%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764692%22%20slang%3D%22en-US%22%3EHelp%20on%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764692%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20use%20two%20cells%20to%20determine%20if%20a%20third%20cell%20should%20be%20copied%20to%20another%20cell%20in%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cells%20I%20will%20be%20using%20will%20be%2C%3C%2FP%3E%3CP%3E%5BSpend%2FProjection%5D%2C%20%5BFunder%5D%2C%20%5BAmount%5D%3C%2FP%3E%3CP%3EBasically%20I%20need%20a%20formula%20like%20if%20spend%2Fprojection%20%3D%20spend%2C%20then%20find%20Funder%20heading%20and%20copy%20and%20paste%20the%20amount%20into%20the%20proper%20heading%20and%20if%20Spend%2FProjection%20%3D%20projection%20then%20leave%20heading%20blank.%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20me%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-764692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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
Highlighted
Have you posted this in the excel forum too??

Adam
Highlighted

@adam deltinger Thats what I thought I did lol

Highlighted
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