I am very new to coding and am trying to make a camera check out/check-in system using a google form and google sheet. I am using a bar code scanner to scan in the camera on the google form which is linked then to the google sheet. Right now I am trying to get the sheet to count how many times the bar code was scanned in and then based on that tell me if the camera is checked in or out. So if the bar code is scanned in only once I now someone checked it out but if it is scanned twice I know it has been returned and then when it appears a third time it is checked out again and so on and so forth.
I have already tried using LOOKUP
but it only searches one row and I want to be able to check in several items at once. I also tried using VLOOKUP
but it doesn't work either.
This is the code that I have so far but it only works once since it only looks if a code has been scanned in once or several times
=If(COUNTIF(Data_Entered!$E$2:$I$6,A2) = 0, "Check In", "Check Out")
I want it that instead of only saying = 0 that I can say = even numbers.
Aucun commentaire:
Enregistrer un commentaire