-1

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?

Kenna CB
  • 1

1 Answers1

0

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
Tedinoz
  • 5,851
  • 2
  • 13
  • 31