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

[Fazree]

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

[Niket_Ghai]

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

[Fazree]

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

[Niket_Ghai]

Comparing two columns in Excel sheet but not rowwise

Hi Everyone, I am not good in excel and i have been given a task which i dont know how should i do it. I have 5 columns in sheet 1 and 6 column in sheet 2. In sheet 1 there is one Column name Debit with amount written in that column it has around 800 rows and in sheet2 also there is a column name Credit.What i have to do is i suppose in sheet1 debit column first value i have taken and i need to search that value in sheet 2 credit column if that amount is present only once in sheet 2 credit col…

This might help you