Vlookup formula where lookup value is a result a formula (receive #N/A error) How fix?
C cpitta Nov 24, 2004 #1 Vlookup formula where lookup value is a result a formula (receive #N/A error) How fix?
J JE McGimpsey Nov 24, 2004 #2 Without seeing what your formula is, it's impossible to do more than guess...
D Dave Peterson Nov 25, 2004 #3 Maybe: =if(iserror(vlookup(...)),"some error message",vlookup(...)) or maybe... =if(isna(a1),"",vlookup(a1,sheet2!a:e,3,false))
Maybe: =if(iserror(vlookup(...)),"some error message",vlookup(...)) or maybe... =if(isna(a1),"",vlookup(a1,sheet2!a:e,3,false))
