Hello everyone,

The following two formulas are identical. Formula#1 gives the desired result but Formula#2 does not.

1) Formula#1 is stating to lookup the work order number in B4. If there is an error, then put a zero otherwise put the relevant value from column 21
2) Formula#2 should be doing the same as above. If there is an error due to the vlookup put a blank, otherwise put the value from column 8. In the event of an error, instead of putting a blank, it is picking up the text of another work order. The text is exactly the same in all the lines where there is an error.

So, what needs to be changed?

FORMULA#1
=IF(ISERROR(VLOOKUP($B4,'P:\WIPSUM\[WIPSUM8.xls]WIPSUM8'!$B$2:$AJ$2000,21)),"0",VLOOKUP($B4,'P:\WI PSUM\[WIPSUM8.xls]WIPSUM8'!$B$2:$AJ$2000,21))

FORMULA#2
=IF(ISERROR(VLOOKUP($B4,'P:\WIPSUM\[WIPSUM8.xls]WIPSUM8'!$B$2:$AJ$2000,8)),"",VLOOKUP($B4,'P:\WIPS UM\[WIPSUM8.xls]WIPSUM8'!$B$2:$AJ$2000,8))

Thanks
SJ