Performing vlookup with Combining the data within cell

nirkisna65

I have two files which would need Vlookup to be performed to update the fields for other, the twist is i need the information of the columns to be joined/combined while performing vlookup. (Col. B and F) highlighted in Yellow.

Unique number is Asset #

I attached the an example of files. First one is the Old, and second Import 2 - update is recent one with updated information.

Import - Old.xlsx

Import 2 - update.xlsx

TomWelgemoed

Hi @nirkisna65 ,

I think you just need to join the data and then concatenate some of the columns?

Please see an image and an example (please add your files to the workflow) attached.Please note that there are some duplicates due to duplicates in the Excel itself. This can be handled of course. You may also need some formatting improvement on the formulas (e.g. only concatenate the values if they differ?), but wasn't sure if that's needed.

Formulas are both following this style: 

if !IsEmpty([US Response])

then [US Response]
+
if !IsEmpty([Right_US Response])
then '.'+[Right_US Response]
else ''
endif
else
[Right_US Response]
endif

Regards,

Tom

Formulas.yxmd