Vlookup using VBA

[pdalal]

Hi ,
I need help writing a VBA Macro tovlookup data from one sheet to another.
I want to lookup values into Book1sample.
This is my formula in C1:

IF(ISNA(VLOOKUP(A1,[Book2sample.xlsx]Sheet1!$A:$B,2,FALSE)),0,VLOOKUP(A1,[Book2sample.xlsx]Sheet1!$A:$B,2,FALSE))

Also I want that if there in numbers in Book2sample.xlsx that do not exist in Book1sample then append those records to column A1 and then do the vlookup again in Range C:C.

I have uploaded the Book1sample ,Book2 sample and the final book1sample needed.
Help!

[Tinbendr]

Put this in a standard module.

Please Login or Register  to view this content.

[pdalal]

I Can work with this ! Thank you !