Populate column based on IF condition

Hello! I need a help with populating column F3 with data from column 2020 in the attached workflow using condition formula. I have two columns with similar data and based on these columns need to populate column F3

I have tried using Formula tool but not able to figure out the correct approach. Thanks!

New Workflow3.yxzp

Workflow

Developer

Tips and Tricks

Connectors

Accepted answers

JosephSerpis

Hi @Ravi you want to use the join tool and also the union tool if you want to perfom a vlookup. I mocked up an approach and believe it matches your expected output.

Join_03122021.yxmd

All comments

JosephSerpis

Hi @Ravi your formula appears to be working when looking at your data only two records should be changed and when looking at the data from the formula tool they appear updated.

Maybe provide an example of the output you want if this dosen't answer your question.

Ravi

@JosephSerpis Thank you for prompt response, I want to do kinda vlookup on column C using Col. B data as Lookup value and get the data from Col I. I have attached the expected output.

Sample - Copy.xlsx

Ravi

Hi @JosephSerpis This is perfect, thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703