Warning: Trying to access array offset on value of type null in /www/wwwroot/app-pack.telkomuniversity.ac.id/wp-content/themes/sinrato/functions.php on line 40
Re: Inventory Tracking Help
Put this formula in C16 of the Equipment Tracking Table:=IF(ISERROR(INDEX(B16:END OF SCHEDULED TABLE RANGE (BOTTOM RIGHT,MATCH(B16,AA15:AA100,0),27)),”INVENTORY”,INDEX(ALL SCHEDULE TABLE RANGE,MATCH(B16,AA15:AA100,0),29))I see merged cells in the Scheduled Table, hopefully that does not create a problemCheers Put this formula in C16 of the Equipment Tracking Table:
=IF(ISERROR(INDEX(B16:END OF SCHEDULED TABLE RANGE (BOTTOM RIGHT,MATCH(B16,AA15:AA100,0),27)),”INVENTORY”,INDEX(ALL SCHEDULE TABLE RANGE,MATCH(B16,AA15:AA100,0),29))
I see merged cells in the Scheduled Table, hopefully that does not create a problem
Cheers
