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

koolkowski - Nov 29, 2017 at 10:44 AM - Latest reply: ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen
- Nov 29, 2017 at 04:13 PM
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
See more 

1 reply

Reply to this topic
ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen - Nov 29, 2017 at 04:13 PM
0
Helpful
LOOk at the Indirect function.

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