multiple nested if(vlookups to linked sheets causes 100% CPU uasgae and crash

=IF(ISTEXT(G2)=TRUE,IF(LEN(G2)>8,IF(VLOOKUP(VALUE(LEFT(G2,6)),'\\Srsbnad\SRSdata\5.0 General Administration\MASTER LISTS\Current JDE Job Status.xls'!status,1)=VALUE(LEFT(G2,6)),"open","Closed"),""),"")


=IF(ISTEXT(G2)=TRUE,"",IF(G2=VLOOKUP(G2,'\\Srsbnad\SRSdata\5.0 General Administration\MASTER LISTS\MASTER PLANT LIST.xls'!RC_Plant_Number,1),"plant found","not found"))

Any suggestions why this is causing 100% CPU usage when these formula are copied down the sheet alongside the new data entered. Even 5 or six new lines copied causes issues, twenty at a time and the sytem grinds to a halt.

Originally Posted by GrahamBlackwell

=IF(ISTEXT(G2)=TRUE,IF(LEN(G2)>8,IF(VLOOKUP(VALUE(LEFT(G2,6)),'\\Srsbnad\SRSdata\5.0 General Administration\MASTER LISTS\Current JDE Job Status.xls'!status,1)=VALUE(LEFT(G2,6)),"open","Closed"),""),"")


=IF(ISTEXT(G2)=TRUE,"",IF(G2=VLOOKUP(G2,'\\Srsbnad\SRSdata\5.0 General Administration\MASTER LISTS\MASTER PLANT LIST.xls'!RC_Plant_Number,1),"plant found","not found"))

Any suggestions why this is causing 100% CPU usage when these formula are copied down the sheet alongside the new data entered. Even 5 or six new lines copied causes issues, twenty at a time and the sytem grinds to a halt.

Don't know if ths will help but you could change the following

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

.

also
replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

( do the same with the second VALUE evaluation)

You might also replace VLOOKUP with

Please Login or Register  to view this content.