search entered value macro / farmula.

[bentxoxo]

Hi All,

Am trying to search entered value which is "item code" in another excel file and bring the item name and put into next column.

File1:
A B
1 Item Code: Item Name
2 1001 Red Dress
3 1002 Green Dress

File2:
A B
1 Item Code: Item Name
2 1002 Green Dress
3

If I enter in File2, Column 1A "1002" macro / formula search File1 Column A:A and bring "Green Dress" and put into File2, Column B.

Thanks in advance,

 

[Special-K99]

in File2!B2
=VLOOKUP(A2,File1!A2:B3,2,0)