Macro to match values

Hi all,

I need a macro to look up for the specific text in a table and if matched on one cell then compare 3 other cells in the same sheet with 3 cells in another sheet in the same file and if they matched to gather then put that specific text in a corresponded cell.
Please check the attached file.

I wrote the formula to do the job. please check columns H and I on sheet1, as an example the formulas in cells h2 will check if cell E2 (in sheet1)=B2(in sheet2) and F2 (in sheet1)=D2(in sheet2) and G2 (in sheet1)=E2(in sheet2) then put the text of H1 in H2.

But this is just a sample, the real file will be a monster file with thousands of cells. So if I use this formula my computer can not open it. sometimes i need it for columns h up to 500 columns further as an example and the sheets will contain thousands of rows.

I need a macro to do it automatically. It should be able to understand how many cells and columns are in both sheets, compare the mentioned cells and do the job.

I really do appreciated in advance.