Find if column contains value from another column?

by

You could try this

=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),FALSE, TRUE)

-or-

=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),"FALSE", "File found in row "   & MATCH(<single column I value>,<entire column E range>,0))

you could replace <single column I value> and <entire column E range> with named ranged. That’d probably be the easiest.

Just drag that formula all the way down the length of your I column in whatever column you want.

Related Contents:

  1. Importing CSV with line breaks in Excel 2007
  2. How to add a custom Ribbon tab using VBA?
  3. When should the xlsm or xlsb formats be used?
  4. Excel formula to reference ‘CELL TO THE LEFT’
  5. Append same text to every cell in a column in Excel
  6. Excel: the Incredible Shrinking and Expanding Controls [closed]
  7. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  8. excel delete row if column contains value from to-remove-list
  9. Closing Excel Application using VBA
  10. Excel how to find values in 1 column exist in the range of values in another
  11. VBA equivalent to Excel’s mod function
  12. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  13. How to avoid using Select in Excel VBA
  14. Stop Excel from automatically converting certain text values to dates
  15. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  16. Is there a way to crack the password on an Excel VBA Project?
  17. How to create a string or formula containing double quotes in Excel?
  18. Excel: last character/string match in a string
  19. Microsoft Excel mangles Diacritics in .csv files?
  20. Find last used cell in Excel VBA
  21. How do I declare a global variable in VBA?
  22. Insert picture into Excel cell [closed]
  23. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  24. Get content of a cell given the row and column numbers
  25. How can I export GitHub issues to Excel?
  26. How to merge rows in a column into one cell in excel?
  27. How can I create a progress bar in Excel VBA?
  28. How can I concatenate strings in VBA?
  29. Detect whether Excel workbook is already open [closed]
  30. Excel Reference To Current Cell
  31. Convert cells(1,1) into “A1” and vice versa
  32. How do I recognize “#VALUE!” in Excel spreadsheets?
  33. DateTime fields from SQL Server display incorrectly in Excel
  34. How can I find last row that contains data in a specific column?
  35. Excel VBA code to copy a specific string to clipboard
  36. Excel CSV. file with more than 1,048,576 rows of data
  37. Pass row number as variable in excel sheet
  38. Does the VBA “And” operator evaluate the second argument when the first is false?
  39. Excel’s fullname property with OneDrive
  40. Case Function Equivalent in Excel
  41. reading Excel Open XML is ignoring blank cells
  42. How can I create a calendar input in VBA Excel?
  43. Border around each cell in a range
  44. How to get the excel file name / path in VBA
  45. Excel compare two columns and highlight duplicates
  46. Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
  47. How do you run a .exe with parameters using vba’s shell()?
  48. Is it possible to replace Excel’s VBA Editor/IDE with a modern alternative? [closed]
  49. How to disable Excel’s automatic cell reference change after copy/paste?
  50. How can I determine the character encoding of an excel file? [duplicate]

Leave a Comment