Help with a Macro

Hi

Formula:

=INDEX(B:B,MATCH(G2,A:A,FALSE),1)

will find the G value in A and return the value from B.

If that's not what you expect please add some manually calculated results.