lookup vba

[Prashod]

Gday all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am after a vba code which could do the lookup for me from a defined range.<o></o>
For example<o></o>
I have Sheet1 and sheet2.<o></o>
Sheet2 has<o></o>
A B <o></o>
aa 1<o></o>
bb 2<o></o>
cc 3<o></o>
dd 4<o></o>
<o></o>
and on Sheet1 I have<o></o>
<o></o>
A B<o></o>
cc<o></o>
cc<o></o>
aa<o></o>
dd<o></o>
<o></o>
I want it to auto populate columnA on sheet1 with all the lookup values from sheet2. It has to do this for all the rows under columnB in sheet1.<o></o>
<o></o>
Any help would be appreciated<o></o>
Thanks in advance<o></o>
<o></o>

 

[GlennUK]

Isn't this just something that a VLOOKUP formula would do?

 

[Prashod]

Hi Glenn,

Yes vlookup or match should do it, but i am trying to running a series of events to create this report. I have completed the others but I am just stuck with this one.
Any help in creating a VBA would be greatly appreciated.

 

[GlennUK]

Use the macro recorder to record putting a VLOOKUP formula into cells to do this.