compare unsorted list

[michaell1963]

hi


I am new to vba and want to ask how to program with vba code to find match between two list that not sorting.

find value in one column that match to other column and return the value next to him.


i need to do it with two workbooks in excel.


i know to do it with two sorting list with index match function in vba code but not know to do it with unsorting list


thanks.

 

[prasaddn]

hi,

why not use Vlookup() formula?

Regards,
Prasad DN

 

[michaell1963]

look in the files

 

[Asheesh]

Could you explain your exact requirement...After looking through data, vlookup will easily do the job..or you may want to use the combination of Index Match..

 

[michaell1963]

i want to do it with vba code not by vlookup

 

[michaell1963]

i want to fill the price and qty by the location filed

 

[Asheesh]

The below link should help..

http://www.exceltrick.com/formulas_macros/vlookup-in-vba/

 

[michaell1963]

as you can see in my files the columns are not in the left side.

can i get help with index function

 

[michaell1963]

I TRIED THE LINK ABOVE AND THE EXAMPLE NOT WORK