Comparing two columns, and returning a specific adjacent cell in Excel
Very similar to this question, and I would suggest the same formula in column D, albeit a few changes to the ranges: =IFERROR(VLOOKUP(C1, A:B, 2, 0), “”) If you wanted to use match, you’d have to use INDEX as well, like so: =IFERROR(INDEX(B:B, MATCH(C1, A:A, 0)), “”) but this is really lengthy to me and … Read more