Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-1994742%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1994742%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20write%20a%20formula%20if%20I%20want%20the%20value%20from%20Sheet1%20column%20A%20displayed%20in%20Sheet2%20column%20a%20if%20Sheet1%20column%20I%20has%20a%20value%20of%20%22x%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1994742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1995017%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1995017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F904208%22%20target%3D%22_blank%22%3E%40Grace410%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20if%20the%20value%20in%20sheet1%20Column%20i%20has%20not%20the%20value%20of%20X%3F%20I%20put%20in%20formula%200%3C%2FP%3E%3CP%3EYou%20can%20change%20it%20to%20whatever%20you%20want%2C%20if%20you%20want%20text%20you%20have%20to%20put%20it%20between%20%22%20%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3DIF(Sheet1!I1%3DX%2CSheet1!A1%2C0)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I write a formula if I want the value from Sheet1 column A displayed in Sheet2 column a if Sheet1 column I has a value of "x"?

1 Reply

@Grace410 

 

What if the value in sheet1 Column i has not the value of X? I put in formula 0

You can change it to whatever you want, if you want text you have to put it between " "

 

=IF(Sheet1!I1=X,Sheet1!A1,0)