Hello,
I am hoping someone here may be able to help me.
I am making a spreadsheet that tracks and logs the location and bookings for work equipment.
Problem 1.
I'd like to make a function that will allow team members to "book in" equipment on a single row and save that data. Then, when someone selects that equipment in a drop down menu it will bring up multiple rows of "bookings" for that piece of equipment. Then, if another row of data is added - being a new booking - this can then be saved and it will show up the next time someone selects that piece of equipment for booking.
I'm not sure if it would be easier to have these functions on two different tabs in the spreadsheet. I know vlookup can be used but can it grab many rows of data attached to a single piece of equipment?
Thanks
Bookmarks