IF Condition - Column 1 (Sheet1) vs Column1 (Sheet2)

Hi Team,

I am facing a little problem in using the IF condition via each row activity.

   * I need to check Column "**Brand**" in Sheet1 vs the Column "Brand" in sheet2 (Kind of vlookup activity).

If the brand is available in sheet2 then I need to write the same in Sheet1 Column C - Available or Not Available.

Can someone help me to solve the same, I am enclosing the relevant files for your reference.

Many Thanks,
Price_Comparison.zip (16.6 KB)

1 Like

here you go
kindly try with this and let know for any queries or clarification
karthik.zip (2.3 KB)

Cheers @Karthik2525

1 Like


Thanks for your advise,

I want to lookup the entire COLUMN A in SHEET1 vs column A in the SHEET2, in this case no products matched between two Sheets in same excel…

so, in this case - as the brand’s are not matching with the 2 sheets and expecting to get “Not Available” as the “OUTPUT” in the “column C” in the SHEET1

Hope you understand my query.

Cheers @Palaniyappan

did LOOKUP DATATABLE activity helped us on this
Cheers @Karthik2525