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 how to accomplish this?

LocationCodeSAPTexas101 Texas101

TX

New Mexico102 New Mexico102NM

​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 how to accomplish this? LocationCodeSAPTexas101 Texas101TXNew Mexico102 New Mexico102NM  Read More

​