Iferror Vlookup

[starchaser_one]

Hi everybody,

I have add a little example concerning Vlookup.
I would like to add a vlookup for column A. The problem is that column A will allways have blanks.
Unfortunately the loop stops at the first blank.
How can I solve this problem, so the formula will skip the blanks and goes on till the last filled cell?

Thanks for your advice.

[Fluff13]

How about

Please Login or Register  to view this content.

[starchaser_one]

Thanks Fluff13... problem solved

[Fluff13]

You're welcome & thanks for the feedback.