Excel 2013 Vlookup List Changes in Separate Column
Posted on 2013-12-18
I'm running a VLOOKUP in Excel to compare names between columns and indicate changes. I'm comparing Columns G and H, and listing results in Column I. What is happening is Column I lists all the same entries in Colulmn G, and the names that don't exist in column H are indicated in column I with an: #N/A
Instead of the #N/A indication of the non-match, I wish to have the names shown that don't match listed in either column I or column J.
I'm using =VLOOKUP(G2,H:H,1,FALSE)