russellday1
New Member
- Joined
- May 12, 2015
- Messages
- 7
So I have a list of locations in A:A , a list of audits in B:B and list of audit results in C:C
What I want to do in a summary sheets is to say if A1 (Location name) = to any cell in A:A AND B1 (Audit name) is equal to the B:B then return the result in C:C - The two conditions and result need to be on the same row.
I have tried IF AND but it gives me a false unless i specify the cells rather than range
Any help appreciated
What I want to do in a summary sheets is to say if A1 (Location name) = to any cell in A:A AND B1 (Audit name) is equal to the B:B then return the result in C:C - The two conditions and result need to be on the same row.
I have tried IF AND but it gives me a false unless i specify the cells rather than range
Any help appreciated