hi everyone

I m trying to convert this worksheet formula

=INDEX($H$1:$H$499,MATCH(D1,$G$1:$G$499,0))

=INDEX(Range to Search,MATCH(Cell to Match, Range in which to search
for match, FALSE)

to macro [in sub, not function ]

no.of rows are unknown .......plz help me convert above formula to vba
code

I hop i get support from u experts as i got earlier
many thanks in advance for u time n effort