Return TRUE/FALSE/NA when comparing between multiple columns between 2 rows

Hi there. I would like to start another column to check if the condition is true, false or NA.

The condition is when the file no. is different but both the id numbers and location tag is the same, what functions should used be used to carry that out? See example below. So, I intend Column E is the column to put the function(s).

Screenshot 2018-10-09 at 12.35.54 PM.png

Thank youu.

Hi Ali

My expected outcome based on the example above is:

New ID number 89 is meant for equipment plate no. A5678 with the location tag side. As the old id number is -, the function (s) returns NA.

So then due to maintenance for equipment with plate no. A5678 at the location tag side, user changed the ID number. So now the previous new ID number 89, is now the old ID number (See Column B, fourth row). The function (s) return TRUE as the ID number 89 matched with the previous old ID number with the same equipment plate no. A5678 and location tag side.

However, user entered wrongly for the next equipment plate no. (See Row 4). Equipment plate no. A1234 also did maintenance on the location tag side but the old ID number 89 is not a match with its previous new ID number, 86 (See Column C, row 2). Therefore, the function (s) return FALSE since both the old id number and previous id number for the equipment plate no.A1234 does not match eventhough the location tag is the same side.

Basically, the user entered the same id number 86 on two different equipments where this id number is located on the same location side.The function (s) is what I hope to be able to detect for these circulstances.

Heehhe, hope it is understandable. Much appreciated.

Hi Samba and Ali

Now that I've written the excel sheet, then I realised that both my previous replies were quite incorrect. Sorry for the confusion

Attached is the excel sheet with the before and after.

Thank you for taking a look at it.

Hi Samba

Yep, works exactly as per intended. Thanks for your help