I would like to import data into a spreadsheet from a page on another spreadsheet, but I would like for the important range to be dependent on a header column containing a certain a certain text (for example: john doe) since the row range (based on A2:R2) is constantly changing due to new data.Here's what I have so far...=IMPORTRANGE(https://docs.google.com/spreadsheets/d/1tIGIfIGHv4R0sj8vSduJGdekd-nxberp4vwud4ChAKo/edit#gid=784492288, Company Contacts!('john doe'))...but I receive a #REF! error.Whereas when I input...=IMPORTRANGE(https://docs.google.com/spreadsheets/d/1tIGIfIGHv4R0sj8vSduJGdekd-nxberp4vwud4ChAKo/edit#gid=784492288, Company Contacts!A2:R2)...it is perfect, but the text in A2:R2 may change, depending on the data being input.Please help if this makes sense.
Import Data for a row on a particular sheet dependent on header column
google spreadsheets