ExcelSeeker
New Member
I am trying to find a work around from manually filtering out the data from a sheet Everytime I have to look up available products of certain range of rates. For example, I need to look for products which are above 10.05%, what I ideally want is that the table populates itself based on available products which are >= to the rate I put in as the lookup range
Is it possible, I am using excel 2016. And yes I know I can use the filter option and look for values based on values but I want to create a new table which fetches data from another table and populates it based on the value I want to look for
Is it possible, I am using excel 2016. And yes I know I can use the filter option and look for values based on values but I want to create a new table which fetches data from another table and populates it based on the value I want to look for