Forum Discussion
Solved
Similar to Index Match Match, Value 1 is Tool# in Range A from database report. Value 2 & Range
I am unable to make the formula complete. This is for a 1,000 + entry report. I have a scaled down example to attache. Tool Log has employee ID as headers and if TOOL ID is Matched in DB Report, and ...
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.
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.