Help with errorhandling

[cajand]

Hello!

In the attached file I have a vlookup subroutine which kicks off if you doubleclick a cell in the range E2:E100.
What it does is that it finds the product number and price for each cell you doubleclick, works great.

But if you for instance manually type an article name and do not manually type the price and article number,
the code returns #N/A, and the next time I doubleclick, it returns "mismatch" error.

How can I adjust the code so that instead of returning #N/A it leaves the cells blank and does not give me the mismatch error?

I've tried replacing "#Value" with "" and also "on error to to 0" with "on error resume to next" but I cant get it to work properply, in the end I always get a mismatch error.

Please Login or Register  to view this content.

Please help!

[:) Sixthsense :)]

Replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[cajand]

Replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Thank you! That removed my mismatch error, but it still prints #N/A if there is no match.
I want it to leave the cells blank.

[:) Sixthsense :)]

May be this??

Please Login or Register  to view this content.

[:) Sixthsense :)]

Or

This??

Please Login or Register  to view this content.

[cajand]

Or

This??

Please Login or Register  to view this content.

This is the keeper! Thanks so much!