Find value and return row in excel spreadsheet with over 1 mil rows I have an excel spreadsheet that has over 1 million rows and about 120 columns. I frequently need to find a value or a part of a value (value is name or number) and return the row where the value is found. I only need values from about 20 columns so I could drop out the extra columns but that does not solve the problem of excel being very slow in finding the value and it is very difficult to read information in the row.

What would you recommend to use for this task? Ideally I would like to enter the value and get the row in some sort of a report but not necessary as long as it is well readable.

I was thinking of using Power BI but got kind of stuck and in the end felt that it wasn't the right tool for the task.

I am open for all suggestions!
the problem of excel being very slow in finding the value and it is
  very difficult to read information in the row


What is "slow" for you (in seconds) and how fast would you like the search to be?

In a lot of cases, the performance can be considerably improved by using INDEX and MATCH to search for values in Excel, instead of using VLOOKUP (which is known to be much slower in comparison).

Alternatively, you could install SQL Server Express on your machine, import the Excel file into a table, and use some SQL statements to find the values you want.

Power BI is a visualization tool, and doesn't seem appropriate for what you're describing which is preparing the data. You could use Power BI after, of course, to plot the final results.