Use vlookup and create that calculation in Excel and use as data source in Tableau.
I have to make huge data extract every week and clean it before uploading to Tableau online. I have made a flow on Tableau Prep which takes care of all the cleaning. This is one column I am calculating on excel. I want to record the calculation on Tableau Prep so updating the data source will not take any time.