Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

TT ADD Formula

I had this question after viewing TT Copy Formula.

Hi Expert,

Need To add One More formula in existing macro...please help me .
In Module M4_Formulas need to add formula for column header Rework/Fresh
Formula is
=IF(ISERROR(MATCH(INDIRECT(ADDRESS(ROW(),MATCH("Batch Number",$A$1:$CC$1,0))),Master!D:D,0)),"Fresh",IF(AND(ISNUMBER(MATCH(INDIRECT(ADDRESS(ROW(),MATCH("Batch Number",$A$1:$CC$1,0))),Master!D:D,0)),OR(INDIRECT(ADDRESS(ROW(),MATCH("Inward Status",$A$1:$CC$1,0)))="",INDIRECT(ADDRESS(ROW(),MATCH("Inward Status",$A$1:$CC$1,0)))="V"),INDIRECT("Master!"&ADDRESS(MATCH(INDIRECT(ADDRESS(ROW(),MATCH("Batch Number",$A$1:$CC$1,0))),Master!D:D,0),MATCH("Open/Close",Master!$A$1:$CC$1,0)))),"Rework","Transit"))

Open in new window


See Attached

Thanks
--TT-WIP-A.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Naresh Patel

ASKER

Perfect