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
Hi,
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