Dec 16 2020 10:03 AM
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"?
Dec 16 2020 10:39 AM
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)