[excel] How to compare two columns in Excel and if match, then copy the cell next to it

I've tried =IF(ISNUMBER(ISMATCH(D2,G:G,0)),H:H,"") to match numbers with a key, here are my rules:

Column D (starting at D2) match with Column G (starts at D2 as well)

If match, then Copy the cell in Column H that is matched through Columns D and G to Columns E

Is there a way to do this with a formula?

Summary

Column E is empty at the start, I want to copy the content of Column H to this column, but only if the row has been matched with column D and G.

try this formula in column E:

=IF( AND( ISNUMBER(D2), D2=G2), H2, "")

your error is the number test, ISNUMBER( ISMATCH(D2,G:G,0) )

you do check if ismatch is-a-number, (i.e. isNumber("true") or isNumber("false"), which is not!.

I hope you understand my explanation.