Retrieving full rows of data from database using multiple criteria

[BenBihi]

Hello guys,

I'm trying to figure out how to return multiple rows from a data set. The multiple rows have a specific number corresponding that encompasses all the rows. I also have a specific condition as to what rows are necessary. I tried figuring out how to do it with INDEX and MATCH, but I wasn't able to do it. Any help is more than welcome.

Thanks guys.

 

[Joe4]

Welcome to the Board!

My first though may be to try to incorporate the use of Fitlers, but it is tough to say for certain, without seeing what your data looks like and getting an idea for what you are trying to return.

You can get images from Excel using this tool here: XL2BB - Excel Range to BBCode

 

[BenBihi]

So essentially I am trying to retrieve a full row of data. The data that I want to return is going to be necessary for making decisions and BBCode isn't accepted in this case. I want it to basically copy and paste the row into another sheet if this makes it any clearer.

 

[Joe4]

So essentially I am trying to retrieve a full row of data. The data that I want to return is going to be necessary for making decisions and BBCode isn't accepted in this case. I want it to basically copy and paste the row into another sheet if this makes it any clearer.

So far, sounds like Advanced Filters would be a good fit for this. You can copy whole rows of data meeting some specified criteria to another location.

See: Excel Advanced Filter Introduction