Google-sheets – How to reference multiple cells in one sheet in one cell in another sheet

google sheets

I am using Google Sheets and I have two sheets in one document (SHEET1 and SHEET2). I want to be able to use a formula that allows me to:

  • If cell A1, B1, D1 and F1 in SHEET1 have an s in them

  • Then cell A1 in SHEET2 automatically inputs an s in it

Can this be done?

Best Answer

In SHEET2 in cell A1, add the following formula:

=IF(AND(Sheet1!A1="s";Sheet1!B1="s";Sheet1!D1="s";Sheet1!F1="s");"s";"invalid")

Is says:

If A1, B1, D1 and F1 in sheet 1 all contain an s then write s else write invalid

Related Topic