Vlookup from another workbook N/A

[Philip00]

Hi All!

I have able to written a code where i can select which workbook i would like to use as a reference.

It works fine however when the vlookup finds data i got N/A despite the exact data

Here is the code

LastRow = Range("B65536").End(xlUp).Row
Range("AA2:AA" & LastRow).FormulaR1C1 = "=IF(VLOOKUP(RC[-25],'" & Destination & "[" & Filename & ".xlsx" & "]Sheet1'!R1C27:R1855C2,26,0)="""","""",VLOOKUP(RC[-25],'" & ActiveSheet.Previous.Name & "'!R1C27:R1855C2,26,0))"

Can somebody knows what can be the issue?

Thank you in Advance,

Philip

 

[Philip00]

Hi All!

I have able to written a code where i can select which workbook i would like to use as a reference.

It works fine however when the vlookup finds data i got N/A despite the exact data

Here is the code

LastRow = Range("B65536").End(xlUp).Row
Range("AA2:AA" & LastRow).FormulaR1C1 = "=IF(VLOOKUP(RC[-25],'" & Destination & "[" & Filename & ".xlsx" & "]Sheet1'!R1C27:R1855C2,26,0)="""","""",VLOOKUP(RC[-25],'" & ActiveSheet.Previous.Name & "'!R1C27:R1855C2,26,0))"

Can somebody knows what can be the issue?

Thank you in Advance,

Philip

Hi Guys!

I found the solution!

Marks pelase this thread as compelte