copy/paste range of cells if cell matches another cell in another worksheet

[Lewis101]

Hi Guys,

Hopefully i explain this correctly, i dont mind if its a macro or formula. ive tried using MATCH and Vlookup and maybe i am over complicating this.

I need:

If a cell in H5:H101 in sheet 'InstallChecks' Matches a cells in H6:H98 in sheet 'ActiveDirectoryIntegration' then copy from cell G6:G98 in sheet 'ActiveDirectoryIntegration'
where match found to cell N5:N101 in sheet 'InstallChecks'

let me know if you need an example file and i will strip out some data.

 

[Lewis101]

*Bump* - Any help would be appreciated.