I have 2 worksheets - 1 worksheet lists the items in stock. Columns are
Items number, Item, description. Each item number is unique. The 2nd
worksheet is a logbook of all the times someone has booked out an item as
well as the current items booked out but not returned yet. Coolums are items
number booked out (same as first worksheet), user who it out, date booked
out and date returned.

I want to add a colum in the first worksheet (item list worksheet) that
looks at the item number column and checks it against all the rows in
worksheet 2 to easily tell me if an item is currently booked out or not. I
want to create a formula that basically looks at all the rows in worksheet 2
(the logbook) and sees if the booked out date is completed but the booked
back in date is not completed (i.e the user has yet to return the item). I
can create a straight forward formula to say how many times an items has
been booked out but not whether it is actively booked out.

Any ideas?

Any help will be much appreciated.

Steve