Excel Automation> Compare columns in 2 different sheets and feed values in another sheet

Sample Excel for PIVOT.xlsx (10.3 KB)

Requirement:
I want to fill Final color value in Sheet2 wrt order number and respective Color value in Sheet1.
for e.g. if sheet1 has color yellow for Order number 3, would want color yellow for all order number with value 3 in sheet2

Thank you so much in advance. Would need excel formula only.
Sheet1:
image
Sheet2:

@anjasing

Just use a join datatable activity and join on ID

Later if you want to remove any columns use filter datatable activity

cheers

=VLOOKUP(A2,Sheet1!$A$2:$B$9,2,FALSE)

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