I have tried to use the ISBLANK function along with the VLOOKUP to see if
the booked back in date is blank (i.e. the item has not been booked back
yet) but this does not work because there are multiple times an item can be
booked out and it seems to check just the first time the item number
appears.

=IF(ISBLANK(VLOOKUP(Worksheet1ItemNumber,Worksheet 2Columns,ReturnedBackDateColumn,FALSE)),"Yes","No" )
- This formula looks at the cell with the item number, finds the occurrence
in worksheet 2 and sees if the returned back date is blank. Problem is that
it checks the rows in worksheet 2 from top to bottom and if an item has been
booked out and returned it will check that row before getting further down
to abother occurrence of the item being booked out and potentially not
returned.

"Steve Jackson" wrote in message
. uk...
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