Comparing two columns, and returning a specific adjacent cell in Excel

by

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 you need to know how to properly use two functions (or three, if you don’t know how IFERROR works)!

Note: =IFERROR() can be a substitute of =IF() and =ISERROR() in some cases 🙂

More Related Contents:

  1. VLOOKUP with multiple criteria returning values in one cell
  2. Vlookup using 2 columns to reference another
  3. Excel VLOOKUP where the key is not in the first column
  4. Two column lookup in table array using INDEX and MATCH
  5. Getting formula of another cell in target cell
  6. If two cells match, return value from third
  7. Excel – VLOOKUP vs. INDEX/MATCH – Which is better?
  8. Comparing two columns on sheet1 to two other columns on sheet2 and returning another column in sheet 2.
  9. Excel VBA – How to add dynamic array formula
  10. Difference between date and time w/out work week Excel
  11. Combine 2 Excel tables into one appending the data?
  12. Compare double in VBA precision problem
  13. Row count on the Filtered data
  14. Excel VBA Macro: User Defined Type Not Defined
  15. Automate IE via Excel to fill in a dropdown and continue
  16. Run-Time error 1004 Excel 2013
  17. Excel VBA to Export Selected Sheets to PDF
  18. Controlling Internet Explorer local intranet using Excel VBA
  19. How to convert a Google Docs-File to an Excel-File (XLSX)
  20. Count unique values in Excel
  21. Get File Path (ends with folder)
  22. Get length of array?
  23. Bad data selection using VBScript , on date field values
  24. Unicode string literals in VBA
  25. How to get the path of current worksheet in VBA?
  26. How to open a workbook specifying its path
  27. Create folder path if does not exist (saving from VBA)
  28. Is it possible to see more than 65536 rows in Excel 2007? [closed]
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment