VLookup Function

[MiroPwC]

Hi guys,

quick question on you. Here below I have data set where SA 2018 are account numbers and I would like to replace column "Description" with relevant Account names based on Account number. For this I also have another file (screen 2)

Screen 2

So I would like to make a code that would replace "1" in Description column with "Individual tangible fixed...". Then replace "2" with ... another English name from the list.

Any help is appreciated.

Thank you

[RolandSchubert · Accepted solution]

Hi @MiroPwC ,

I think, you could join the tables based on SA 2018 and Account and use a formula to fill the description field. I've attached a sample workflow. Hope this is helpful.

Best,

Roland

[estherb47]

Hi @MiroPwC 

You can join both tables on the SA 2018 and Account fields. Uncheck "Account" from the Right side, and uncheck "Description" from the left side (in the select tool part of the Join tool). You can then more the account name into position with the arrows, also in the Select tool part of Join.

Let me know if that helps.

Cheers!

Esther

[fmvizcaino]

Hi @MiroPwC ,

Attached is an example showing how to do it. 

Take a look and let me know if this works for you.

BEst,

Fernando Vizcaino