Compare 2 excel file using if condition

Help
1

Continuing the discussion from If conditions case:

Hi, if I have excel sheet column header “name” with a list if name. Instead of hard-code the string for comparison, how do I perform by extra the column header “name” from another excel to perform the comparison?

I can’t upload the workflow because I am a new user.

2

Find the workflow where i am comparing two columns from two excel sheetMain.xaml (9.4 KB)

3

Hi, thanks for providing the workflow. Does your column have a header to decide which column the code is comparing between 2 excel sheet?

I am trying to compare 1 column header is Name which include many names (sheet1), on another column header (sheet 2) is member contains the names shown on column (“Name”) on sheet 2.

Sheet 1 Sheet 2
Name member
Ben
Jenny
Jason
Peter