H.G.
I do a lot of work in excel and agree with Tom's advice, you should use a conditional "if" statement. The one below will trap all errors except for #N/A which is good because this error tells you that the value you are looking up isn't in the table.
IF(ISERR(VLOOKUP(lookup value,table,index #,FALSE))," ",VLOOKUP(lookup value,table,index #,FALSE))
The "if" is also useful for catching #Div/0! errors. Whenever I divide something I put an "if" statement in as a matter of habit now. Something like this:
IF(A1 =0,0,E1/A1)
regards, john |
