How to compare two columns in Excel and if match, then copy the cell next to it - Stack Overflow

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 c... ... It might be easier with vlookup. Try this: =IFERROR ..

stackoverflow.com