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.
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.
SergeiBaklan Thank you so much that accomplished just what I needed. Now I can do a quick view of all tools assigned. I may be interested in pulling the "Status" into the cell instead of placing the text "In Report"... That would give me the true snap shot of employee, ownership of tool, and status. Great Job!