SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

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

What I want to do is to say if the contents of cell D3 (on current worksheet) exist in column A in the first worksheet (in my case entitled list). (and they always do exist somewhere). Return the contents of the corresponding row in Column C.

In other words if the matching cell is found in Row 12 - return data from C12.

I've used the following syntax but I can't seem to get the last part to work correctly.

=IF(ISERROR(MATCH(D3,List!A:A, 0)), "No Match", VLOOKUP(D3,List!A:A,1,TRUE))

How to fix the formula?

This question is related to excel excel-formula vlookup excel-match

The answer is

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).

Source: Stackoverflow.com

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