Forum Discussion
Similar to Index Match Match, Value 1 is Tool# in Range A from database report. Value 2 & Range
In G11 it could be
=IF(ISNA(MATCH($C11&G$10,$C$19:$C$29&$J$19:$J$29,0)),"no","In Report")and drag it to the right and down. If I understood the logic correctly.
I wasn't able to figure out how exactly you've laid out your Log section, but have written just three formulas here in this example that show one way to deliver the result you appear to be looking for. I'll let you adapt them to your layout.
In the example, I've used the UNIQUE function to get a list of the three employee IDs that you provided in your example. That formula is in cell N8. I also used SORT to put them in order.
That list is used to provide a data validation drop down list in cell P8. If you just select a different employee there you'll see the results to the right of it change. That's all you need to do to test what I've created. All the rest is automatic.
In cell Q8 there's a FILTER function that just lists the tool# for tools assigned to the selected employee.
In cell S8, FILTER is used to list not only tool#, but also Job, Loc, Asset, and Type....
Note: UNIQUE, FILTER and SORT all are only available in the most recent version of Excel, so if these aren't working for you when you open it, that would be an indication that you're on an older version of Excel.
mathetes Interesting! I think I can use this for a more Employee in depth report. Thank you for you help.
Those Dynamic Array functions are amazing in their various applications. I only recently became aware of them...this YouTube video was very helpful in getting a grasp on how they work and how they might be used. https://www.youtube.com/watch?v=9I9DtFOVPIg
I'd encourage you to set aside time to watch it as well.