Vba lookup with initial

[RJ1969]

Hi,

This code works for a while until I tried to use an initial with a period. Example C. Santos, Mario L. Lopez, V. Rodriguez. But if I don’t use the initial with a period it works.

Is there any better code to use so I be able to use the period with an initial? Thanks.

Please Login or Register  to view this content.

thanks.

[6StringJazzer]

What you posted is a worksheet formula, not VBA code.

How is the name Sheet2 defined?

Do you mean that it works if you don't use an initial at all? Or it works if you use the initial but without a period?

I think it would help to attach your file because this is a data issue. See yellow banner at the top.

[RJ1969]

Ok..
Here it is. When I select C. Smith then the error #N/A exist. But the rest were ok. Thanks.

[RJ1969]

I also noticed that I changed the initial to R. Smith then it will work.
For some reason the C. and D. initials are not working with the code.

Thanks.

[Fluff13]

You need to change the 1st vlookup to include False as the final argument.

[RJ1969]

Hi Fluff13
I don’t understand what you meant. Sorry...

[Fluff13]

It should be
=IF(Y18="","",IF(VLOOKUP(Y18,Sheet2,2,FALSE)="", "", VLOOKUP(Y18,Sheet2,2,FALSE)))
the same as you have in the 2nd vlookup

[RJ1969]

Hi Fluff13

I think it worked. Thank you so much.

[Fluff13]

Glad to help & thanks for the feedback.