SyntaxFix

[excel] Check if an excel cell exists on another worksheet in a column - and return the contents of a different column

You can use following formulas.

For Excel 2007 or later:

=IFERROR(VLOOKUP(D3,List!A:C,3,FALSE),"No Match")

For Excel 2003:

=IF(ISERROR(MATCH(D3,List!A:A, 0)), "No Match", VLOOKUP(D3,List!A:C,3,FALSE))

Note, that

  • I'm using List!A:C in VLOOKUP and returns value from column ? 3
  • I'm using 4th argument for VLOOKUP equals to FALSE, in that case VLOOKUP will only find an exact match, and the values in the first column of List!A:C do not need to be sorted (opposite to case when you're using TRUE).

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to excel-formula

• Excel doesn't update value unless I hit Enter • Referencing value in a closed Excel workbook using INDIRECT? • Conditionally formatting cells if their value equals any value of another column • Sum values from multiple rows using vlookup or index/match functions • What does an exclamation mark before a cell reference mean? • If two cells match, return value from third • Excel - programm cells to change colour based on another cell • Format numbers in thousands (K) in Excel • Excel Formula which places date/time in cell when data is entered in another cell in the same row • Excel formula to display ONLY month and year?

Examples related to vlookup

• Check if an excel cell exists on another worksheet in a column - and return the contents of a different column • "Unable to get the VLookup property of the WorksheetFunction Class" error • Comparing two columns, and returning a specific adjacent cell in Excel • VLook-Up Match first 3 characters of one column with another column • Combining COUNT IF AND VLOOK UP EXCEL • Excel- compare two cell from different sheet, if true copy value from other cell • Vlookup referring to table data in a different sheet • Excel - find cell with same value in another worksheet and enter the value to the left of it • Remove #N/A in vlookup result • Excel vba - convert string to number

Examples related to excel-match

• If two cells match, return value from third • Check if an excel cell exists on another worksheet in a column - and return the contents of a different column • Comparing two columns, and returning a specific adjacent cell in Excel • Return Max Value of range that is determined by an Index & Match lookup