Hi,
I have a Input file where there are certain trades for which I need to apply Vlook up to fetch details from RAM file and give me output in result file. Please help me to apply Vlook-up for the trades which has comments as CAM & MDR (in last column). My objective is that I need to see the output as same as in Result file. Please help
Attaching the relevant files.
Hi @HULK Use a join tool and jone Trade ID & Trade Ref. Because you have duplicates in the input file, you may want to summarize first before joining to avoid a cross join. There are plenty of great resources linked above.
Give it a go and attach your workflow if it's not working - better than having your work done for you.