Hi,
If i am doing a VLOOKUP to another sheet, and if it is not on that sheet, i want to return '0' rather than #N/A.
What formula can i use please?
I am currently using =IF(ISERROR((VLOOKUP(I2,'Rebate 6 wks'!$L$3:$M$77,2,FALSE))=0),0,VLOOKUP(I2,'Rebate 6 wks'!$L$3:$M$77,2,FALSE)). is there a shorter one?!
Thanks
Bookmarks