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

koolkowski - Nov 29, 2017 at 10:44 AM
 Blocked Profile - Nov 29, 2017 at 04:13 PM

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


1 reply

Blocked Profile
Nov 29, 2017 at 04:13 PM
LOOk at the Indirect function.

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