Hi
When one of the three conditions is true, which returns a "PM12345", I get a blank cell "". I also used ISTEXT, but did not help. How can I get around this?
=IF(OR(ISNUMBER(VLOOKUP(H4982,'Bob''s V3'!K:K,1,0)=H4982), ISNUMBER(VLOOKUP(H4982,MFG!A:A,1,0)=H4982), RIGHT(H4982,5)>="17000"),"V3","")
Thanks,
When one of the three conditions is true, which returns a "PM12345", I get a blank cell "". I also used ISTEXT, but did not help. How can I get around this?
=IF(OR(ISNUMBER(VLOOKUP(H4982,'Bob''s V3'!K:K,1,0)=H4982), ISNUMBER(VLOOKUP(H4982,MFG!A:A,1,0)=H4982), RIGHT(H4982,5)>="17000"),"V3","")
Thanks,