VLOOKUP

[Mel]

I am using Vlookup to get information from another
worksheet however when the worksheet does not match the
selected criteria iI get a #N/A. I was wondering if it
would be possible to created a nestd if function so that
when I get this as a response I could replace it with a
0. Please help me!!!!!!!!!



Thanks

 

[Guest]

Yes, You could use

IF(ISERROR(VLOOKUP(XXXX)),0,VLOOKUP(XXXX)

I hope to be helpful

A


----- Mel wrote: ----

I am using Vlookup to get information from another
worksheet however when the worksheet does not match the
selected criteria iI get a #N/A. I was wondering if it
would be possible to created a nestd if function so that
when I get this as a response I could replace it with a
0. Please help me!!!!!!!!



Thank