DVD Database Search with Google Sheets

Hi in advance.

I have a simple database of DVD's and a handheld barcode scanner. I want Column A to have the DVD Title and Column B to have the barcode number which I will have added in advance so that Columns A and B are fully populated. What I would like to add is Column C to have 'Loaned out Yes/No', Column D to have a 'Loan Date', Column E to have 'Borrower Name' which would be manually entered. Column F to have a return date (which could be 2 weeks for example) - ideally to have it highlighted when going beyond the return date. The ideal situation would be to have someone who wants the DVD to hand it to me, I scan it and it highlights the DVD so that I can enter if it has either been loaned or returned. Does that make sense?

I would love to but I work in a prison and can't send any data. But even if I had a test sheet with 5 records in Column A (DVD 1, DVD 2, DVD 3, DVD 4, DVD 5) etc. and Column B to have 123, 234, 345, 456, 567 for example to replicate what I would have?

The layout is pretty much it (I can pretty up columns for aesthetics without a worry). I already have got the barcode scanner to work and fill in cells on Google Sheets so I know that Columns A & B won't be a problem. Would I need an additional 'search or input cell' to click into, then scan the DVD whereupon it populates that search cell as a trigger for earlier formulas? So that by scanning the DVD it searches for the corresponding barcode entered earlier, highlights the DVD so that I can enter loaned or returned and who by.

Hi,

That's OK, I only tried here and this particular sub-forum as it mentioned the other platforms. Thanks very much for assisting though thus far. I will look to see if there is an alternative Google Sheets forum to get more specifics.

Hi All - and apologies I pasted this originally in the wrong forum in error.

I have tried to play around with this but I do know that Sheets is different from Excel. But what I have attached, shows the barcode that automatically populates Column B when using a handheld scanner to build the library. Then when someone loans something, I put yes in Column C which populates Column D and in turn gives a return date in Column F. I am not sure how to remove the value in cell F3 for example which shows as 14 even when not loaned out, it would be great if that value was determined by Column C. Is there a way to highlight a cell in column F when the date goes beyond the expected return date so that I can then locate the lender to retrieve the item - perhaps as a separate box that is always on view, something like outstanding titles or something? I have downloaded the Sheets document into Excel to be able to upload here.