Mar 13, 2020
Merging the Importrange with the IF function?
We have a drop-down list with the statuses "No" and "Posted" on column B, repeated on every cell of column B, to let us know when something has been posted or not yet.
We would like to find a way to import the data from a particular ROW onto a different sheet every time a specific selection is made on the drop-down list for that same ROW, (e.g.: when drop-down list is set to "posted"), the information is sent to the other sheet.
We've tried using the IMPORTRANGE function, however, we would need a way to connect it to an "IF" function ( i think it should be the "IF" function) so that it only sends the data when the wanted item is selected on the drop-down list ("Posted").
Anyone can please give us feedback on this problem?
Thanks in advance
Mike
Details
Community content may not be verified or up-to-date. Learn more.
Last edited Mar 13, 2020
All Replies (3)