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.
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