Index/Match or Vlookup for retrieving data from rows?

Hi,

I've posted here once before and received great advice and help so I thought I'd come back and give it another shot. I have a table of five years of hourly data for five variables, including LOAD. I want a table of the all entries where the LOAD variable is greater than or equal to 800. So for example, if I had

LOAD A B C D
200 2 3 4 5
600 3 4 5 6
800 2 4 5 6
900 3 4 5 6

it would return

800 2 4 5 6
900 3 4 5 6

How would I go about doing this? Any advice would be appreciated. Thanks!

While that would work, I was hoping for a more dynamic solution, because I want to be able to change the 800 value at will rather than just sorting the data manually.

Only looking at the data in your example, the easiest/quickest way to see this is to turn your data into a data table select only one cell in the range and go to the inset tab and click Table. Then filter the data for Greater than or equal to 800 or any way you want. If you need to keep that data on a separate sheet just copy and paste it from the table.

you could use an =if(x>=800, vlookup,x,range,n,0) type formula but the table filters are much faster and less complicated.

Indeed, the table filters are much easier if I was working with only one example, but I will be making a lot of changes to inputs and will be dealing with multiple datasets so I would prefer a formula. If I were to use the formula you provided, what would I look up for vlookup? I thought vlookup only returned values less than or equal to x.

If you want to quickly change the variable and data try the attached