VLOOKUP

  • Thread starter Thread starter Mel
  • Start date Start date
M

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
 
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
 
Back
Top