Hi, very basic knowledge but I have a sheet which my team can pick the name of an inspector on a drop down from a list of 5, the date they are visiting from a list of around 10, and the status of the visit (confirmed / unconfirmed)
I have used this formula to look through the sheet and compile a summary sheet to show the number of bookings the inspector has on each date:
I now need to look through the sheet and where the name,date and status return a match I need the formula to return the value already in cell 1,2,3 which are the property name, postcode, address.
This would be used to create the list of properties for each inspector on each date.
Any help would be very much appreciated
Joe
Related:
If cells match 3 criteria return the data already in 3 others
