How to check two different excel columns are matching and update them?

Help Studio
, ,
1

For example:
I want to check Employee ID in Sheet 1 and ID in Sheet 2 is matching

Screenshot (94)
Screenshot (94)1920×1080 151 KB

Screenshot (93)
Screenshot (93)1920×1080 153 KB

If matching I need to update them as the following:
Screenshot (95)
Screenshot (95)1920×1080 152 KB

2

Hi,

Hope the following sample helps you.

img20220331-5
img20220331-51134×817 35.5 KB

Sample20220331-4.zip (10.6 KB)

Regards,

3

thank you so much for the help bro :two_hearts:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.