Bonnie Janes
New Member
- Joined
- Apr 27, 2017
- Messages
- 36
Hi, I have a spreadsheet which logs service sheets, services carried out on certain dates, I need a look up page that looks at two criteria, "Discipline" & "Location", then returns the most recent date, as there will be several.
I also need a formula that will bring through all entries, once two criteria have been selected, this I've done before with a macro I think but there might be a formula that will do the same?
Yes, I know I can filter the whole thing to show me what I need, but I need to build something an idiot can operate! I was thinking macro buttons instead, but I know this is possible with INDEX MATCH, but I can't get the formula to work.
Can anyone help?
I also need a formula that will bring through all entries, once two criteria have been selected, this I've done before with a macro I think but there might be a formula that will do the same?
Yes, I know I can filter the whole thing to show me what I need, but I need to build something an idiot can operate! I was thinking macro buttons instead, but I know this is possible with INDEX MATCH, but I can't get the formula to work.
Can anyone help?