Replace #N/A by a formula

[bryan444]

Hello,

I'd like to know how could I replace the #N/A by a specific formula that will do the following
At the first date when a stock has a data, apply a formula which is (First day of quotation of stock B / this same day of stock A) * (stock A -1day)

Please look at the screenshot with explanations I made
explication excel vlookup et conditions en.jpg


And here is my code

Please Login or Register  to view this content.

And here is the link to the file https://docs.google.com/open?id=0B1X...1d0dW9yOEs0NmM

Best regards,

R

[JOHN H. DAVIS]

Maybe replace this:

Please Login or Register  to view this content.

with this?

Please Login or Register  to view this content.

[bryan444]

Thanks!
But not working... :-(

[JOHN H. DAVIS]

What does it return?

[bryan444]

error 1004, yellowing the formula

[JOHN H. DAVIS]

Try replacing with this:

Please Login or Register  to view this content.