vba lookup

[michaell1963]

hi i am new to vba and want to use xlsm file that i uploud ,but if can any one help me to to do it simple to understand with two coloum only and to compare value and not date.

thanks..

 

[Deepak]

Hi,
Nothings sounds...
So, pls take liberty to explain more!!!

 

[michaell1963]

HI

 

[Deepak]

Still unclear....

 

[michaell1963]

1 vba code,not excel formula
2 looping by vba code to find match
3 use index and match in vba not lookup

 

[michaell1963]

CONVERT THIS FORMULA TO VBA CODE
=IFERROR(INDEX($C$3:$C$7,MATCH(G9,$B$3:$B$7,0)),"")
WITH LOOPING

 

[michaell1963]

my meaning is to do macro between two worksheets