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.
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.
What IF I wanted more specific information in the "If FALSE" statement of the IF formula?
=IF(ISBLANK($B$3),"",IF(ISNA(MATCH($B3&$S$2,Up2Date!$A$2:$A$20000&Up2Date!$H$2:$H$20000,0)),"no","In Report"))
What would I need to do to get the associated value from the STATUS Column in place of "In Report" text?
...&Up2Date!$H$2:$H$20000,0)),"no","In Report")) change to $H$20000,0)),"no",R2W))
or as may be associated.You may expand it with INDEX/MATCH as
=IF(ISNA(MATCH($C11&G$10,$C$19:$C$29&$J$19:$J$29,0)),"no", INDEX($H$19:$H$29,MATCH($C11&G$10,$C$19:$C$29&$J$19:$J$29,0)) )Result is
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!
