Vlookup

[Cloud67]

Hi,

I am trying to execute following code, this code matches first 10 characters of two columns and if it matches then it copy and paste it in the workbook.

/code

.Formula = "=VLookup(LEFT(A2,5),'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A:

/code

it is working with this code but it is returning only five char in the column and when i try the wildcard it is giving me the mismatch error,.

/code
.Formula = "=VLookup(LEFT(A2,5)& " * " ,'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A:$AK,{1},False)"

code/

Will appreciate the help
Thanks

 

[Logit]

[COLOR=#333333].Formula = "=VLookup(LEFT(A2,5),'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A:[/COLOR]

This portion of the code determines how many characters to copy : LEFT(A2,5)
The 5 means 5 characters. What happens when you change that to 10 ?

 

[Cloud67]

Then it copy 10 characters. I thought this part is matching the number of characters.

 

[DanteAmor]

Try:

.Formula = "=VLookup(LEFT(A2,5)&""*"",'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A:$AK,1,False)"

 

[Cloud67]

OMG it works! Thanks a lot Dante Amor. Thanks to logi too.

 

[Logit]

You are welcome.

 

[DanteAmor]

OMG it works! Thanks a lot Dante Amor. Thanks to logi too.

I'm glad to help you. Thanks for the feedback.