Hi,
I have a workbook with different sheets and I'm trying to return cell contents from one sheet to another !!!! only the cells that have content. For the ones that don't have content, I'd like Excel to simply ignore them.
Sheet 1 is a recap of all orders placed online & the info I need from sheet 1 are:
in Col.A => Order #
in Col. I => If client ordered insurance there is text in the cell, if client did NOT ordered insurance the cell is blank
Objectif:
1) If client ordered an insurance, copy the text from Sheet 1 Col.I (Insurance#) into Sheet 2 Col.F
2) & if client ordered an insurance, copy the Order# from Sheet 1 - Col.A into Sheet 2 - Col. E
So far, I have worked with the formula below to select the cells with text from Sheet 1 - Col. A and copy them into Sheet 2 Col.F:
=iferror(index('Import Master Sheet'!I:I,SMALL(INDEX(NOT(ISBLANK('Import Master Sheet'!I:I))*ROW('Import Master Sheet'!I:I),0),countblank('Import Master Sheet'!I:I)+ROW('Import Master Sheet'!I3))))
Thanks a bunch for the precious help!!
Bookmarks