Forum Discussion
Index Match only blank cells
I have a dataset which contains only partial data in one column (SAP below). I have the data in another table, but I only want to INDEX/MATCH the blank fields in the SAP column below. Any thoughts ho...
Thanks OliverScheurich. Let me clarify because I missed a detail. I need to fill in only the blank fields in the SAP column. I'm guessing this might need a "helper" column and then copy/paste into the original.
Your are welcome. I misunderstood your question unfortunately and i'm still not 100 % sure if i understand correctly. Please check if the attached sample file works for you. All the data for the SAP column is now in column D. This could be the "helper" column. Then you can copy the whole column D and paste only values in column C.
