Hello!!

good day to you.

i am looking for a macro to vlookup on a different workbook

workbook 1 workbook 2
col A col B col A col B
id value id value

111 #n/a 111
111 25 121
111 25
121 45
121 45

when i vlookup on workbook 2 with the id 111 i want to get 25 in column b...the ids are already in the workbook 2..so i need to apply it to the whole column B to display the values.

is there a suitable macro i can use

thanks in advance


Gokz