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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
=if(B1="partner",importrange("<insert the url for spreadsheeth#2>","wa_13682302!A1"),"")
You need to combine: