How can I search for a name in a table first by number associated and then by date?
Our take
I'm trying to create a tracker that would allow me to see who last took out a numbered key. I want to create a table in which each row is a record of when a numbered key was taken out and then returned.
I am currently using an XLOOKUP function to find a name associated with a key number. So you can see in the example that key 1 has two records, one for Bobby and one for Timmy. But Timmy took it out last and it's pulling Bobby's name.
I also used a MAX function in K6 to pull the latest date from the Date Issued column.
I essentially want to combine these so that I can input a number and it searches for the record associated with that number, and then searches those records for the most recent date and provides me with the name for that.
I have taken some classes on excel but I have never had to do anything quite like this, so I'm not sure if there is a better way to do this. I am asking how to combine the XLOOKUP and MAX but if there is another function that would better suite this search type please let me know.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience