If string is "Not assigned" then lookup with another table else return the existed text

[bgonen]

Trying to create a new column (Market Field2) if the string in column "D" contains "Not assigned" then lookup another little table and compare the Profit center with the profit center in the other little table to get the correct Market field name,

else, if column "D" NOT contain "Not assigned" then return the text in column "D"

The other table looks like this:

[bgonen · Accepted solution]

Thank you for your help.

I found this solution below 

[amitchandak]

@bgonen , there are few ways you can access of data of other table and then compare it

refer my video for that : https://www.youtube.com/watch?v=czNHt7UXIe8