Changing a IF(VLOOKUP) into VLOOKUP

[JRidge]

Hi all,

I am currently using this formula:

Please Login or Register  to view this content.

Can this be changed to a VLOOKUP formula and keep the same results.

As always, You help is greatly appreciated

regards

Jeremy

[haripopuri]

VLOOKUP will return error if no matching is found. You can mask the error using IFERROR like below

Please Login or Register  to view this content.

[rajansettu]

Please Login or Register  to view this content.

'

try above one

[JRidge]

Hi and Thank You Both,

When i put this in my VBA script and run it, it fill the cells ok but then comes up with the following err.

My Code:

Please Login or Register  to view this content.

The Error i get is:

Laufzeitfehler 1004
Anwendungs- oder objektdefinierter Fehler

Any Ideas

[haripopuri]

JRidge, you should have mentioned that you are going to use this in VBA

Please Login or Register  to view this content.

[JRidge]

Hi hari.

Sorry Should have mentioned that..

Ok that works fine except all the cells that have nothing in now have 0 in... I need them blank !!

Any Ideas

[haripopuri]

I get blanks bud. Can you share your workbook?

[JRidge]

I Definatly get all zeros where cells are empty

[JRidge]

Bit Complicated to use....

[JRidge]

The piece of code is used in the "MitArbeiter Zuweisen" Userform, "Save" Button

[haripopuri]

JRidge, as I said VLOOKUP will return error only if it could not find what you are looking for. In your workbook, the date you are looking for is found and VLOOKUP returned the 3rd column value which is 0. No problem with the formula.

If you want the 0s to blank. You have to use IF.

[JRidge]

Then i go back to my IF(VLOOKUP) version..

Thanks for your help.

Regards

Jeremy