I have a third-party dataset showing transactions for various geographies across EMEA. I have - seperately - a list of in-house classifications (for instance, grouping different types of retail use. I have tried doing a join to join the in house fields to the third-party data. I have tried to use the "Use" column - retail, logistics, data centre etc. - to append the in house descriptors to the dataset. However, as the in-house descriptors do not cover all of the categories in the use column, it the resulting joined dataset is missing a large number of records.
I am thinking in terms of a VLOOKUP almost, where I could use an if statement to effectively say if the USE column contains Retail, then lookup, else, "".
Is there a better way to do this (inevitably, yes!), or any suggestions about how to ignore, but keep, blank entries?
DOC
