manpreet35
New Member
- Joined
- Sep 28, 2018
- Messages
- 1
Hello,
My excel file is getting very heavy & opening minutes to open, due to the formula below pasted in all rows of Table6, I want to get any alternate VBA code to arrive at values using similar search criteria s.
=INDEX(Table1[MARK NO./DESCRIPTION],MATCH(CONCATENATE([@[WO No]],[@NS]+10,[@PG]+10,[@[MA ]]+100,[@DU]+100),Table1[CONCATENATE],0),1)
Where
Table 1 is created in worksheet that contains shipping list of materials (DATABASE)
Table 6 is material entry sheet, which after putting the material code, pulls the description from Table 1 based on the concatenate figure arrived using similar logic as visible in formula
Kindly on above is possible
My excel file is getting very heavy & opening minutes to open, due to the formula below pasted in all rows of Table6, I want to get any alternate VBA code to arrive at values using similar search criteria s.
=INDEX(Table1[MARK NO./DESCRIPTION],MATCH(CONCATENATE([@[WO No]],[@NS]+10,[@PG]+10,[@[MA ]]+100,[@DU]+100),Table1[CONCATENATE],0),1)
Where
Table 1 is created in worksheet that contains shipping list of materials (DATABASE)
Table 6 is material entry sheet, which after putting the material code, pulls the description from Table 1 based on the concatenate figure arrived using similar logic as visible in formula
Kindly on above is possible
