If cells match 3 criteria return the data already in 3 others

Closed
Report
-
 Blocked Profile -
Hello,

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:

=COUNTIFS('2017 Inspections'!M4:M486,"22/01/2018",'2017 Inspections'!N4:N486,"=Lynda Hall",'2017 Inspections'!O4:O486,"Confirmed")

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

1 reply


LOOk at the Indirect function.

A better solution would be a Database, with a daily report based on inspector and date.