How to write if condition for row A and row B is true


#1

Hi All

how to write if condition for situation like this:

a) Excel sheet name EXCEL 1 should read exact match in REFERENCE LIST.
b) If figure Simpan in EXCEL 1 is match with Simpan in REFERENCE LIST = true
otherwise, bot will throw false.

Appreciate to help me
Thanks

Untitled


#2

Are these two different excel sheets? Or two separate sheets?


#3

Hi niket

Its 2 different excel sheet. I design excel app - read range - for each loop - get row text for 2 excel sheet - … and i believe i need to make if condition. May you help me sir pls


#4

This might help you :slight_smile: