VLOOKUP issues

Hi, there.

Hopefully you'll be able to help me. I have a vlookup function, and as you can probably guess I recieve some #N/A values. I need to change somehow the function to desplay instead of "#N/A" a "0" value or to let the cell stays blank. I was thinking of using IF function and tried some different ways to define it but no luck for now.

Any suggestion.
Thanks in advance.

For best understanding you should include some of your trials as code and a short description of what you suppose to do, with results you wanted.

Perhaps you need a conditional formula to avoid error N/A, something like :

Please Login or Register  to view this content.

try this


=if(iserror(Vlookup(........),"",Vlookup(........)))

This tests to see if the lookup gives an error, if it does then blank, if not, the result of the lookup.


Ed

=VLOOKUP(A103,'13.06.07'!$B$1:$C$321,2,FALSE)

is the initial function. I need to add somehow I guess IF condition, so #N/A not to appear at all, leaving the rows for which no data available will stay blank

Originally Posted by EdMac

try this


=if(iserror(Vlookup(........),"",Vlookup(........)))

This tests to see if the lookup gives an error, if it does then blank, if not, the result of the lookup.


Ed

EdMac that worked just fine , thank you very much.

Cheers

Glad to have helped.

Thanks for the feedback

Ed