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.

[Qiu]

@nirkisna65 
@TomWelgemoed has given the perfect answer for your first query.
For the second one, we can manipulate the Tables with Table Tool by applying Row Rule or Column Rule, or Global settings.

Hope this helps.