IF different from blank then

[ced0802]

Hi everyone,

I would like that in my column Number 3 (workbook deliveries macro) that if the cell is blank it doesn't do the Vlookup and goes to the next one.
I don't have any error message but the result is that it still does the 2 vlookup (one with blank into braket+ the other one)

Please Login or Register  to view this content.

Let me know if you have an idea why it doesn't stop when it sees blank cells.
Huge thank you.

[alansidman]

I don't have a technical answer, but an alternative to the If-then statement may be

Please Login or Register  to view this content.

[ced0802]

Thank you for your message.
I'm not really sure if the problem comes from the IF. I am a bit confused, don't really know what the problem is.

MACRO MODULE 5 :

In workbook "macro deliveries", I would like the quantities sheet ''feuil1'' column C to be transfered into workbook "Wk49"
column 5 to have for instance :

5N - 2Y [+17000]on Del 21.02

It works BUT it puts values for every cells in workbook "WK49". (I'd like to keep for instance 5N-2Y when no values on first Workbook)

5N - 2Y [] on Del 21.02 instead of 5N - 2Y

Thank you very much in advance for all your help ! (hope it makes sense)