matching data

[tonylpcs@yahoo.co.uk]

Hi Everyone,

Hope this should be quite easy,

I need a formular to do the following:

If G1 = Any data in any cell in Colum H then whatever details are in colum J of the same row as the matching data in H is copied to F1. if not 0.
can anyone let me have the formular for this please?

thanks for your help.

Tony

 

[VoG]

Try

=IF(ISNA(MATCH(G1:H:H,0)),0,INDEX(J:J,MATCH(G1,H:H,0)))

 

[tonylpcs@yahoo.co.uk]

Thank you so much.

Tony