IF THEN Google Sheets - referencing different workbook

Question

I'm hoping to do the following:

Spreadsheet 1, cell A1: pull in data from cell A1 in Spreadsheet 2, but ONLY if cell B1 contains exact text of "partner". Is this possible?

Answer 1

Try:

=if(B1="partner",importrange("<insert the url for spreadsheeth#2>","wa_13682302!A1"),"")

You need to combine:

• IMPORTRANGE: to get the value of Cell A1 from Spreadsheet#2 doc ref
• IF: to create an expression to test the value in cell B1, and then return values based on whether the expression is true or false. doc ref